Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Sql server Óë vs.netµÄ°²×°ÎÊÌâ

ÔÚÏȰ²×°ÁËvs.net 2008 ºóÔõô°²×° Sql server 2005¡£ËÑÁ˺ܶàÎÄÕ£¬¿ÉÊÇ»¹ÊÇûÓп´µ½Ôõô²ÅÄܹ»°²×°ÉÏ¡£

×ÜÊÇÔÚ°²×°sql serverµÄ¿Í»§¶Ë£¨management studio£©Ê±ºò±¨´í£¬×°ÄǸöÊý¾Ý¿â server ÒýÇæµÄʱºòûÓÐÎÊÌâ¡£°Ñ.net frameworkÐ¶ÔØÁËÒ»ºó£¬»¹ÊÇ×°²»ÉÏ¡£ºÃÏñ˵ÒѰ²×°µÄ°æ±¾±È´ý°²×°µÄ°æ±¾¸ß£¬Éý¼¶Ê§°Ü¡£¸ã²»Çå³þµ½µ×ÒªÐ¶ÔØ×°vsʱºò×°µÄÄÇЩ×é¼þ¡£

ÓÐûÓиßÊÖ¸ø¸ö¿ÉÒÔÓõķ½°¸°¡£¬ÐèÒªÏÈÐ¶ÔØÄÇЩ¸ö×é¼þ£¡£¡Ð»ÁË
¹þ¹þ£¬ÎÒÊÇÏȰ²×° µÄ2005£¬ÔÙ×°µÄVS2008 ,û·¢ÏÖÎÊÌâ

ÏÈ2005ºó2008°É£¬Ã»°ì·¨£¬.net frameworkʼÖÕ²»¹»Îȶ¨



End_rbody_60301788//-->
¸Ã»Ø¸´ÓÚ2009-10-11 09:02:57±»¹ÜÀíԱɾ³ý



¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP








cedar_zhao
(cedar_zhao)

µÈ¡¡¼¶£º



#4Â¥ µÃ·Ö£º20»Ø¸´ÓÚ£º2009-10-10 21:11:21



ÈçÐèÒªÔĶÁ¸Ã»Ø¸´£¬ÇëµÇ¼»ò×¢²áCSDN!




Ïà¹ØÎÊ´ð£º

sql ʱ¼äÎÊÌâ

sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001

ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......

×Ü»áÅöµ½¹ÖµÄÎÊÌ⣬sqlÎÊÌâ

sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and  xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and  ......

sql ÎÊÌâ

PBÖпª·¢µÄ¡£

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......

Çë½Ì¸÷λ´ó¸çÒ»¸öSqlÎÊÌ⣬Äĸö°à¼¶µÄ½Ìʦ´ýÓö×î¸ß£¿

СµÜ×î½üÓöµ½Ò»¸öÎÊÌ⣬ҪÇóµÃ³öÄĸö°à¼¶µÄ½Ìʦ´ýÓö×î¸ß£¬°Ñͬһ¸ö°à¼¶µÄ½Ìʦ´ýÓöºÏ¼ÆÆðÀ´


°à¼¶±í                  ½Ìʦ±í

°à¼¶ID    & ......

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ