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

ÐÂÉú£¬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 µ


Ïà¹ØÎÊ´ð£º

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......

ÇóÒ»¸ösql Óï¾ä

  table1
  Ãû³Æ      Èë¿âÊý
  CT»ú        3   
  CT»ú        5
  X¹â»ú      4 ......

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿

ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿
ÀýÈ磺
ALTER PROCEDURE [dbo].[sp_1]
@SYS_LNNO varchar(20),
@SYS_CALLER varchar(20),
        @SYS_ORGANIZE varchar(10), ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
  101 50 08£º00 08£º30 30 40 50  
  101 50 09£º00 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ