Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Óï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......

SQL×ֶΣ¬ºáÏòÕ¹¿ª

ÇëÎʸ÷룬ÈçºÎ½«SQlÖУ¬Ä³×Ö¶ÎÖеÄÖµºáÏòÕ¹¿ªÄØ£¬
CASE WHEN

¾ßÌåÎÊÌâ¾ßÌå·ÖÎö£¬¿´ÄãÒªÔõôչ¿ª

ÐÕÃû  ¿ÆÄ¿      ³É¼¨
ÕÅÈý  Ó¢Óï    90
ÀîËÄ  Ó¢Óï&nb ......

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ