ºØÖÝÊм²²¡Ô¤·À¿ØÖÆÖÐÐÄSQL serverÊý¾Ý¿âÖÃÒɳɹ¦ÐÞ¸´
ºØÖÝÊм²²¡Ô¤·À¿ØÖÆÖÐÐÄËùÓõÄZmSoft´ÓÒµÌå¼ìÐÅÏ¢ÍøÂçϵͳV2010.1.26 Õýʽ°æ²ÉÓÃSQL SERVER2000ƽ̨,²»Ã÷ÔÒò,Êý¾Ý¿â"ÖÃÒÉ“,¿Í»§ÊÔ¹ýËùÓÐÍøÉÏ·½·¨,δÄܽâ¾ö.ÉòÑô¿ÎÄÊý¾Ý»Ö¸´ÖÐÐÄSQLÊý¾Ý¿â¹¤³Ìʦ³É¹¦½«Æä½â¾ö.
ÉòÑô¿ÎÄÊý¾Ý»Ö¸´ÖÐÐÄMS SQL SERVERÑз¢Ð¡×éÖÂÁ¦ÓÚMsSqlÊý¾Ý¿â¼¼ÊõµÄÑо¿¡£¾¹ý¶àÄêÑо¿ÍêÈ«ÕÆÎÕÁËSqlServer6.5¡¢SqlServer7¡¢SqlServer2000¡¢SqlServer2005¡¢SQLServer2008Êý¾Ý¿âµÄÄÚ²¿½á¹¹¡£¿ª·¢ÁË×ÔÖ÷SQL SERVERÊý¾Ý¿â»Ö¸´¹¤¾ß£¬¿ÉÒÔÐÞ¸´MsSqlÒѾË𻵵ÄÊý¾ÝÎļþ£¨°üÀ¨MDF£¬DAT£¬BAKÎļþ£©´Ó¶ø½«Êý¾Ý´ÓMsSqlÊý¾Ý¿âÎļþ»ò±¸·ÝÎļþÖлָ´³öÀ´,Ó²ÅÌÐÞ¸´¡£
±¾ÖÐÐÄÉó¤:
Ms Sql ServerÊý¾Ý¿âµÄÔÖÄѻָ´
(1)ϵͳ±ÀÀ£Ö»Ê£ÏÂSqlserverÊý¾ÝÎļþµÄÇé¿öϵĻָ´.¼´ÎÞÈÕÖ¾Îļþ»òÕßÈÕÖ¾ÎļþËð»µÇé¿öϵĻָ´
(2)SqlServerÊý¾ÝÎļþÄÚ²¿´æÔÚ»µÒ³Çé¿öϵĻָ´¡£
(3)ÔÚSql Server2000¡¢SqlServer2005ÔËÐÐÔÚ¼òµ¥ÈÕ־ģʽ¡¢ÍêÈ«ÈÕ־ģʽ»òÕß´óÈÝÁ¿ÈÕÖ¾¼Ç¼ģʽÏÂÊý¾Ý±»Îó(drop¡¢delete¡¢truncate£©É¾³ý±í»Ö¸´µÈ.
(4)Sql ServeÎļþÎÞ·¨¸½¼ÓÇé¿öϵÄÊý¾Ý»Ö¸´¡£
(5)Sql ServerÊý¾Ý¿â±»±ê¼ÇΪ¿ÉÒÉ£¬²»¿ÉÓõÈÇé¿ö.
(6)Sql Server2000¡¢SqlServer2005Êý¾Ý¿âSysObjectsµÈϵͳ±íËð»µÎÞ·¨Õý³£Ó¦ÓÃÇé¿öϵĻָ´.
(7)Sql ServerÊý¾Ý¿âÖ»ÓÐÊý¾ÝÎļþ ûÓÐÈκÎÈÕÖ¾µÄÇé¿öϵĻָ´.
(8)Sql ServerÊý¾ÝÎļþ±»Îóɾ³ýÇé¿öϵĻָ´.
(9)Sql Server2000¡¢Sql Server2005Êý¾Ý¿âmasterÊý¾Ý¿âË𻵶øÎÞ·¨Õý³£ÔËÐÐÇé¿öϵĻָ´¡£
(10)Sql server»¹Ôʱ±¨Ò»ÖÂÐÔ´íÎ󣬴íÎó823µÈÇé¿öϵÄÊý¾Ý»Ö¸´,¸÷ÖÖ´íÎóÌáʾµÄÊý¾Ý¿âÎļþÐÞ¸´
(11)¿É»Ö¸´ÒòÓ²ÅÌ»µµÀÔì³ÉµÄÊý¾Ý¿âËð»µ
(12)¿ÉÐÞ¸´ÈÕÖ¾ÊÕËõ»òͻȻ¶ÏµçºóµÄÊý¾Ý¿â
(13)Ö§³ÖËùÓеÄSQL°æ±¾
(14)¿É»Ö¸´¶à¸ö¹ØϵÐÍÊý¾Ý¿â
(15)¿É»Ö¸´SQLÊý¾Ý¿âBKF±¸·ÝÎļþ
(16)´ÅÅÌÕóÁÐÉϵÄSQL SERVERÊý¾Ý¿â±»Îó¸ñʽ»¯µÈÇé¿öϵÄÊý¾Ý¿â»Ö¸´
(17)¿É½øÐÐSQL SERVERÊý¾Ý¿â¸ñʽ»¯£¬Îóɾ³ý£¬ËùÓÐÊÐÃæ»Ö¸´Èí¼þÎÞ·¨»Ö¸´Çé¿öϵĻָ´£¬¼´ËéƬ¼¶Êý¾Ý¿âÌáÈ¡»Ö¸´¡£
Ö»ÒªÄúÓÐÊý¾ÝÎļþ£¬ÉòÑô¿ÎĽ«Äܹ»×î´ó³Ì¶ÈµÄ»Ö¸´ÄãµÄÊý¾Ý¿â¡£
¼´Ê¹ÄúûÓÐÊý¾ÝÎļþ£¬Ö»ÒªÌṩÔÀ´Êý¾Ý¿â´æ´¢µÄÓ²ÅÌ£¬ÉòÑô¿ÎÄÒ²¿É½øÐÐ×îµÍ²ãµÄËéƬ¼¶Êý¾Ý¿â»Ö¸´¡£
¡¡
ÒÔÉÏÇé¿ö,ÊDZ¾ÖÐÐÄÒÑÓдóÁ¿³É¹¦°¸Àý.ÔÚÆäËû¹«Ë¾»Ö¸´²»ÂúÒâµÄ¿Í»§,¿ÉÔÚ±¾ÖÐÐĵõ½ÒâÏë²»µ½µÄÊÕ»ñ.
¾ßÌåÇé¿ö,ÇëÀ´µç×Éѯ:13386848847 024-81296855 024-31065488 24Сʱ
ÍâµØ¿Í»§¿ÉÒÔ¼ÓÎÒ¹
Ïà¹ØÎĵµ£º
¾ßÓй̶¨ÓÐЧλÊýºÍСÊýλÊýµÄÊýÖµ×ÊÁÏÀàÐÍ¡£
decimal[ (p[ , s] )] and numeric[ (p[ , s] )]
¹Ì¶¨ÓÐЧλÊýºÍСÊýλÊýµÄÊý×Ö¡£µ±Ê¹ÓÃ×î´óÓÐЧλÊýʱ£¬ÓÐЧֵÊÇ´Ó - 10^38 +1 µ½ 10^38 - 1¡£decimal µÄ SQL-92 ͬÒå×ÖÊÇ dec ºÍ dec(p, s)¡£numeric µÄ¹¦ÄÜÏàµ±ì¶ decimal¡£
p (ÓÐЧλÊý)
¿É´¢´æµÄ×î´óÊ®½øλÊý×ÜÊý£¬Ð¡ ......
Case¾ßÓÐÁ½ÖÖ¸ñʽ¡£¼òµ¥Caseº¯ÊýºÍCaseËÑË÷º¯Êý¡£
--¼òµ¥Caseº¯Êý
CASE sex
WHEN '1' THEN 'ÄÐ'
WHEN '2' THEN 'Å®'
ELSE 'ÆäËû' END
--CaseËÑË÷º¯Êý
CASE WHEN sex = '1' THEN 'ÄÐ'
  ......
ÏÐÀ´Ð´ÏÂwith cubeµÄÓ÷¨
cubeÔËËã·ûÔÚ SELECT Óï¾äµÄ GROUP BY ×Ó¾äÖÐÖ¸¶¨¡£¸ÃÓï¾äµÄÑ¡ÔñÁбíÓ¦°üº¬Î¬¶ÈÁк;ۺϺ¯Êý±í´ïʽ¡£GROUP BY Ó¦Ö¸¶¨Î¬¶ÈÁк͹ؼü×Ö WITH CUBE¡£½á¹û¼¯½«°üº¬Î¬¶ÈÁÐÖи÷ÖµµÄËùÓпÉÄÜ×éºÏ£¬ÒÔ¼°ÓëÕâЩά¶ÈÖµ×éºÏÏàÆ¥ÅäµÄ»ù´¡ÐÐÖеľۺÏÖµ¡£
ÏÈ¿´ÏÂ±í£º
ÎÒÃÇÒÔid¾ÛºÏ²éѯ³öƽ¾ù·Ö
ÕâÒ»ÌõSQLÓï¾äÓ ......
Ò»¡¢SQL ServerÖÐÊý¾ÝÐеĴ洢·½Ê½
ÔÚSQL ServerÖдæ·ÅÊý¾ÝµÄÎļþ»áÒÔ8KBµÄ´óС·ÖÒ³¡£Ã¿Ò»Ò³¿ÉÒÔÊÇÊý¾Ý¡¢Ë÷ÒýÒÔ¼°ÆäËûSQL ServerÊý¾Ý¿âÐèҪΪÆäά»¤Êý¾ÝÎļþµÄÊý¾ÝÀàÐÍ¡£´ó¶àÊýÒ³ÊÇÊý¾ÝÒ³»òË÷ÒýÒ³¡£Ò³ÊÇSQL Server¶Á¡¢Ð´Êý¾ÝÎļþµÄµ¥Ôª¡£Ã¿Ò»Ò³Ö»°üÀ¨Ò»¸ö¶ÔÏóµÄÊý¾Ý»òË÷ÒýÐÅÏ¢£¬ËùÒÔÔÚÿһ¸öÊý¾Ý ......
SQL ½Ì³Ì
1£©SQL ¼ò½é
SQL(Structured Query Language£¬½á¹¹²éѯÓïÑÔ)ÊÇÒ»¸ö¹¦ÄÜÇ¿´óµÄÊý¾Ý¿âÓïÑÔ¡£SQLͨ³£Ê¹ÓÃÓÚÊý¾Ý¿âµÄͨѶ¡£ANSI£¨ÃÀ¹ú¹ú¼Ò±ê׼ѧ»á£©Éù³Æ£¬SQLÊǹØϵÊý¾Ý¿â¹ÜÀíϵͳµÄ±ê×¼ÓïÑÔ¡£SQLÓï¾äͨ³£ÓÃÓÚÍê³ÉһЩÊý¾Ý¿âµÄ²Ù×÷ÈÎÎñ£¬±ÈÈçÔÚÊý¾Ý¿âÖиüÐÂÊý¾Ý£¬»òÕß´ÓÊý¾Ý¿âÖмìË÷Êý¾Ý¡£Ê¹ÓÃSQLµÄ³£¼û¹ØϵÊý¾Ý¿â¹ ......