ÐÂÉú£¬Win7£¬¸ÃÑ¡Ôñʲô°æ±¾SQL£¿
СµÜÕý×¼±¸×Ô¼ºÌáǰѧϰÊý¾Ý¿â£¬µ«ÊÇÏÖÔÚÓиöÎÊÌ⣬²»ÖªµÀ¸ÃÑ¡Ôñʲô°æ±¾µÄSQL
ѧУÒÔºóµÄÊéºÃÏñ½²SQLÓõÄÊÇSQL 2000£¬µ«ÊÇÎÒµÄϵͳÊÇWindows 7£¬Ã²ËƲ»ÄÜ×°£¬Ò²²»Ïë»»»ØXP£¨07Äê¾Í²»ÓÃXPÀ²£©£¬ËùÒÔÔÚÏ룬ÄÜ·ñ×°ÆäËû°æ±¾µÄSQL£¬SQL 2005Ìý˵ÓмæÈÝÎÊÌ⣬ҪװSP3²¹¶¡£¬SQL 2008 Ã²ËÆÍêÈ«¼æÈÝ£¬SQL 2005ºÍ 2008µÄ²î±ð´óÂð£¿
ÎÒÓùýVS 2005 ºÍ VS 2008£¬ÏÖÔÚÔÚÓÃVS 2008£¬¸Ð¾õ¾ÍÎÒÕâÖÖ³õѧÕßÓõ½µÃ¹¦ÄÜÀ´Ëµ£¬²î±ð²»´ó£¬»ù±¾Ò»ÑùµÄ²Ù×÷£¬²»ÖªµÀSQL 2005 ºÍ SQL 2008 ²î±ðÈçºÎ
»¹ÓУ¬SQL 2000 ºÍ SQL 2005 ²î±ðÌý˵Óеã´ó£¨Ã²ËÆËµÊ²Ã´Óï·¨¶¼ÓÐÇø±ð£¬ÕæµÄô£¿£©
Çë¾ÑéÈËÊ¿¸øÐ¡µÜÖ¸µãÏÂÀ²
http://passport.csdn.net/ActivateUser.aspx?UserName=liweilovexue8543&Code=t8uuQn%2fLS9L8FRDkF12K9oDjgsjvwmINiYcw%2boYSx9S%2fV9nIEwLNl7uSix7PzsxeAfCC134xr%2fNihyIXa0X8ZtNL32iKMUp1
¶ÔÁË£¬Èç¹û×°SQL£¬¾ßÌå¸Ãװʲô°æ±¾£¿¸öÈ˰棿ÆóÒµ°æ£¿¿ª·¢°æ£¿£¨²»Òª¼òÒװ棩
2008 ÆÆ½â°æ
SQL SERVER2008 ºÍ SQL SERVER 2005Ïà²î²»ÊǺܴó.
°²×°¿ª·¢°æ¾Í¹»ÁË,SQL SERVER2008ÆóÒµ°æ¹À¼ÆÒª°²×°WIN7 ÆóÒµ°æ»òÕßÆì½¢°æ²Å¿ÉÒÔ°²×°.
¸øÄã¸ö×îÍêÈ«µÄ»Ø´ð°É£¡
ÓÉÓÚÆ®Ò×ÊÖÀïÓÐÏîÄ¿ÐèÒªÓõ½Microsoft SQL Server 2005Êý¾Ý¿â£¬µçÄÔÀïÔÓеÄmssql2000ÒѾ²»ÊÊÓÃÁË£¬µ½ÍøÉÏѰÕÒ SQL Server 2005¼òÌåÖÐÎÄ¿ª·¢°æµÄÏÂÔØµØÖ·£¬Ò»¿ªÊ¼ÏÂÔØÁ˸öѧϰ°æµÄexpress£¬¿ÉÏÞÖÆÌ«¶à£¬»¹ÊǾöÐݲװ¿ª·¢°æ±¾µÄ¡£
µ½Î¢ÈíµÄ¹Ù·½ÍøÕ¾Ñ°ÕÒÁËһЩÊÚȨ×ÊÁÏ£¬ÌùÔÚÏÂÃæ£º
Microsoft SQL Server 2005 ¿ª·¢°æÊ¹¿ª·¢ÈËÔ±Äܹ»ÔÚ32λºÍX64ƽ̨µÄ»ù´¡ÉϽ¨Á¢ºÍ²âÊÔÈÎÒâÒ»ÖÖ»ùÓÚSQL Server µ
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
ÈçºÎµ÷ÊÔ»òÊä³ö´øSqlParameterµÄsqlÓï¾ä£¿
UP
µ÷Óô洢¹ý³Ì£¬ÉèÖÃParameterDirection.Output²ÎÊý
execÔËÐÐsqlÓï¾ä£¬·µ»ØsqlÓï¾ä
ÉèÖöϵ㣬°´ F11 µ¥²½¸ú×Ù..
ParameterDirection.Output
Õâ¸ö²Å¶Ô°É ......