¿ª·¢ÊÖ»úWAPÊÖ»úÍøÕ¾ÎÒÓÃSql2005¿ÉÒÔÂð£¿
¿ª·¢ÊÖ»úWAPÊÖ»úÍøÕ¾ÎÒÓÃSql2005¿ÉÒÔÂð£¿
¿ÉÒÔ
ÎÒÍøÉÏÏÂÔØÁ˺öàÀý×Ó£¬Ëû¶¼ÊÇÓÃSQL Server MobileÊý¾Ý¿â£¬ÄãÄܸøÎÒÒ»¸öÊÖ»úÍøÕ¾µÄÀý×ÓÂð£¿
¿ÉÒÔ¿ÉÒÔ¡£
ÎÒ²»ÓÃSQL Server Mobile£¬Ö±½ÓÓÃSQL Server 2005 Express¿ÉÒÔÂð£¿ËÄܸøÎÒÒ»¸öÀý×Ó
Ïà¹ØÎÊ´ð£º
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
Id Name Flag
1 ÕÅÈý 1
2 ÍõÎå 3
3 ÕÅÈý 1
4 ÀîËÄ 2
5 ÕÅÈý 1
6 ÀîËÄ 2
ÎÒÏëÊä³öµÄʱºò±ä³ÉÕâÑù
Id Name Flag
1 ÕÅÈý 1 & ......
CREATE PROCEDURE [selectvipcompany]
@username varchar(50),
@companyname varchar(50),
@endtime varchar(1)
AS
declare @sql varchar(1000)
set @sql=''
if (@username<>null and @username ......
CREATE PROCEDURE [selectvipcompany]
@username varchar(50),
@companyname varchar(50),
@endtime varchar(1)
AS
declare @sql varchar(1000)
set @sql='' ......
Êý¾Ý¿âÒªÔõôѧ²Å²»»áÏԵóéÏó°¡£¿
Õâ¾ÍÒª¿´ÄãÊʺÏʲô·½·¨ÁË£¬Õâ¾ßÌå²»ºÃ˵µÄ.....
ÔõôÁË£¬ÄѵÀ´ó¼Ò¶¼²»»á£¬»¹ÊÇÕæµÄÌ«³éÏó´ó¼Ò²»ÖªµÀÔõô˵°¡
½áºÏÄã²Ù×÷Êý¾Ý¿âµÄÌå»áºÍÀí½â£¬Ó¦¸ÃЧ¹û»á¸üºÃ¡£·ñÔò£¬Ò ......