ÓйØSQL server2005
ÔõôÓ𡣿²éѯ·ÖÎöÆ÷¶¼ÕÒ²»µ½..555
Â¥Ö÷±ð¼±ÂýÂýÀ´¡£¸Õ½Ó´¥ÐÂÈí¼þ¶¼ÕâÑù¡¡
¿´×ŽçÃæÆ«×óÉÏÄÇÀïÓÐÒ»¸ö°´Å¥ÊÇ¡°Ð½¨²éѯ¡± È»ºóÑ¡ÔñÁ¬½Ó ¾Í¿ÉÒÔÁË
²éѯ·ÖÎöÆ÷,Äãµã¿ª¾ÍÌáʾÁ¬½Ó,ĬÈÏÊÇLOCALÖ±½ÓÁ¬½Óѽ,È»ºóÑ¡ÔñÊý¾Ý¿â,д²éѯѽ
´ò¿ª
SQL SERVER MANAGEMENT STUDIO
¿ªÊ¼²Ëµ¥µÄ Microsoft SQL Server 2005 ÏÂÃæÓиö SQL Server Management Studio
¶¼ÊÇÇ¿ÈË.ɶ¶¼¶®.
ҪôûװSQL2005¿Í»§¶Ë¹¤¾ß
×°Á˵ϰֱ½ÓÆô¶¯SSMS
Ïà¹ØÎÊ´ð£º
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
table1:
uID uName
1 СÀî
2 СÕÅ
table2:
pID uID type
1 1 H1
2   ......
СµÜÎÒÓÃADOÁ¬½ÓSQL server 2000Êý¾Ý¿â£¬È»ºóÔÚDBGridÖÐÏÔʾ£¬ÏÖÔÚÏë°ÑÔÚDBGridÖвéѯµ½µÄÊý¾ÝiPlot×÷ͼ£¬ÇëÎÊÈçºÎʵÏÖÔÚDBGridÖеÄÊý¾Ý¶ÁÈ¡£¬¶Á³öµÄÊý¾ÝÊÇSTRINGÀàÐ͵ģ¬ÈçºÎÓÐЧµÄת±ä³ÉÊý¾Ý¿âÖÐËù´æ´¢µÄDOUBLEÀàÐ ......
ÏÖÔÚÓÐa1,a2Á½±í
a1
id name aa cc
001 aaaa bbb cc
002 bbb bbb bbb
003 ccc ccc ccc
004 ddd ddd ddd
005 eee eee eee
a2
id ida2 ff b ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......