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

°ïæ½éÉÜÒ»±¾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 ϵÁеġ£


Ïà¹ØÎÊ´ð£º

¹ØÓÚgroup byµÄsqlÓï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

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

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

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

ÇósqlÓï¾äÀí½â

±íA
¿¨ºÅ        ʱ¼ä
1                null
2                null
3      ......

sql±à¼­¹¤¾ß

´ó¼Ò¶¼ÓÃʲôsqlÓï¾ä±à¼­¹¤¾ß£¡»¹ÊÇÖ»½ÓÓòéѯ·ÖÎöÆ÷£¿ÍøÉÏÕÒÁËЩPL/SQL developerÕâºÃÏñÊÇÁ¬OraclerµÄ
ÎÒÖ»ÏëÒª¸öSQl±à¼­¹¤¾ß
SSMS.

²éѯ·ÖÎöÆ÷×ã¹»ÁË

±¾ÈË×î½üÔÚѧϰsql
µ«Ã¿´Î¶¼ÒªÍù²éѯ·ÖÎöÆ÷ÉÏÌ ......

¸üÐÂsqlÓï¾ä

ÎÒµÄÓï¾äΪstr1.Format("UPDATE wz set title='%s',class='%s',nr='%s',[date]='%s' WHERE num='%d'",
m_bt, strTemp, fromClipboard, time5,m_num);
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ