°ïæ½éÉÜÒ»±¾sql 2005µÄÊé
ÒÔǰÔÚѧУѧµÄÊDZʼǻù´¡µÄ½Ì³Ì
ÏëÂò±¾sql 2005·½ÃæµÄÊéÏ£ÍûÉÏÃæÀýÌâ±È½Ï¶à£¬½²µÄÄÜÏêϸµã
֪ʶµãҪȫ
ÎÒÒ²ÏëÖªµÀ.
ÖåÀÏ´óµÄÊé
jf
Áº¸çÄãÄÇôţ¶¼ÄܳöÊéÁË¡£¡£¡£
ÉîÈëdz³öSQL 2005¿ª·¢¡¢¹ÜÀíÓëÓ¦ÓÃʵÀý
http://product.dangdang.com/product.aspx?product_id=20228858
Õâ±¾ÊéÈçºÎ°¡¡£¡£¡£
×ÞÀÏ´óµÄÊ黹ҪÐÞÁ¶Ò»¶Îʱ¼äÔÙÑо¿
ÆäʵmsdnÉÏÃæµÄÁ·Ï°¸ú×Å×öÒ»±éÓÃÐĵãÒ²¾Í²î²»¶àÁË
http://search.book.dangdang.com/search.aspx?key=%C9%EE%C8%EB%C7%B3%B3%F6SQL+2005%BF%AA%B7%A2%A1%A2%B9%DC%C0%ED%D3%EB%D3%A6%D3%C3%CA%B5%C0%FD&catalog=01&SearchfromTop=1
ÀÏ´óµÄÊé Ö±½Ó¿´ ²»ÐèÒªÐÞÁ¶ Ò»¿ªÊ¼¾ÍÄѵãºÃЩ
ÕÂÁ¢ÃñµÄ¡¶SQL SERVER 2005Êý¾Ý¿â¿ª·¢ÊµÕ½¡·ÕâÊÇÒ»±¾ºÜºÃµÄÊ飬ºÜ¶àʵÀý
ѧÊý¾Ý¿â£¬×îºÃ¿´ÍâÎÄ¡£ÌرðÊÇinsde microsoft ϵÁеġ£
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß
µ¼Èëµ¼³ö¹¤¾ß.
DD
¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä
Ö±½ÓÐ ......
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç "2009-01","8949-232"
½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......
±íA
¿¨ºÅ ʱ¼ä
1 null
2 null
3   ......
±íÖеÄÒ»¸öÊôÐÔÁÐchoiceÓÐÁ½ÖÖ¿ÉÄܵÄÖµ£ºstringA,stringB£¬¶¼ÊÇ×Ö·û´®¡£
ÎÒÓÃÒ»¸öresult(stringÀàÐÍ£©´æ´¢Ñ¡ÔñµÄ½á¹û
SELECT * from tablename WHERE choice = res ......