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 table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001
ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......