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

ÎÒҪѧ´æ´¢¹ý³Ì£¨VB.NET,SQL£©¹òÇó½Ì³Ì~~

ÈçÌâ~~
MSDN£¬Google£¬Ïëϵͳѧ½¨Ò黹ÊÇÂò±¾Êé¿´°É£¬±Ï¾¹ÊÖ´òµÄ´úÂë¼ÇÒäÒª±È¸´ÖƵÄÉî¿Ì¡£

ÎÒÒª±ßѧ±ßÓÃÔÚ´úÂëÀïÃ棬¿Ï¶¨ÒªÊÖ´òµÄÁË


¿´¿´sql server 2005µÄ°ïÖúºÜÈ«Ãæ»ò¿´¿´Êé
http://topic.csdn.net/u/20090806/09/0274a33c-b670-4886-92f5-7289339f2010.html

網ÉÏ應該ÓкܶàµÄ
×£¸£···

Ç廪´óѧ³ö°æÉçµÄ½Ì²Ä SqlServer 2000
ͦ³ö´í

http://download.csdn.net/source/1644211

ÎÒÕâÀïÓÐÒ»±¾ºÜ²»´íµÄÊ飬½²µÄºÜÏêϸ£¬Ë¼Â·ºÜÇåÎú£¡
¡¶Visual basic.NET+SQL ServerÊý¾Ý¿â¿ª·¢ ´Ó»ù´¡µ½Êµ¼ù¡· ÕÅÖÇÒã µç×Ó¹¤Òµ³ö°æÉç 2006.3.1
Ï£Íû¶ÔÄãÄÜÓÐËù°ïÖú£¡

Óж¯Á¦¾ÍÒ»¶¨ÄÜѧµ½ÖªÊ¶

×öÈËÓйÇÆøµã£¡
ÏÖÔÚÖ»Òª»áÓÃËÑË÷ÒýÇæ¾Í»ù±¾ÉÏ¿ÉÒÔÕÒµ½ÐèÒªµÄ¶«Î÷£¬ÉõÖÁÔìºËµ¯µÄ¼¼Êõ¡£


Ïà¹ØÎÊ´ð£º

sql server ´æ´¢¹ý³ÌÑ­»·¸³ÖµµÄÎÊÌâ

СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
    @p001 nvarchar(8000),
    @p002 nvarchar(8000),
    @p003 nvarchar(8000),
  & ......

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ï棡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεĻ°¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

sql ÎÊÌâ

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

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......

SQL ¶à±í²éѯ²é³öËùÒªµÄÊý¾Ý£¿

ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо­¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøʱ¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
  101 50 08£º00 08£º30 30 40 50  
  101 50 09£º00 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ