°ïæ½éÉÜÒ»±¾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 ϵÁеġ£
Ïà¹ØÎÊ´ð£º
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
pln_id memo
1 ÎÒÊÇ
1 ÄãºÃ
2 ÄãÊÇ
2 ÎÒºÃ
½á¹û
pln_id memo
......
±íA
¿¨ºÅ ʱ¼ä
1 null
2 null
3   ......
ÏÂÃæµÄÈÕÆÚÎÒÒªÓñäÁ¿±íʾ
µ«ÎÒ½ÓÊÕµÄÈÕÆÚµÄ¸ñʽÓëÏÂÃæ²»Í¬
ÎÒ½ÓÊÕµÄÈç 2009-10-10
ÎÒÓ¦¸ÃÔõô±äÄØ£¿
ÿ´Î¶¼°Ñ date1 ºÍdate2ÓÃString ÕâÑùÊDz»ÊDz»ºÃ
SQL code:
between '" ......