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

²»Í¬SQL Server°æ±¾¼äµÄÊý¾Ý¿â»Ö¸´ÎÊÌâ

      ÔÚÕâÀï,ÎÒËùÖ¸µÄ°æ±¾ÊÇÖ¸µÄ2000,2005,2008ÕâÑùµÄ°æ±¾Çø±ð,¶ø²»ÊÇÆóÒµ°æ,¿ª·¢°æÕâÑùµÄ°æ±¾Çø±ð.´Ó¹Ù·½µÄ˵·¨À´¿´,SQL ServerÊÇÔÊÐíÊý¾Ý¿â´ÓµÍ°æ±¾Ïò¸ß°æ±¾»Ö¸´,µ«²»Ö§³Ö¸ß°æ±¾ÏòµÍ°æ±¾µÄ»Ö¸´,Èç¹ûÎÒÃÇÓø߰汾µÄÊý¾Ý¿âÔڵͰ汾µÄÊý¾Ý¿âÒýÇæÏ»ָ´,»á³öÏÖʲô´íÎóÃèÊöÄØ?
    Êý¾Ý¿â»Ö¸´Ò»°ãÊÇÖ¸Á½¸ö²ãÃæµÄÒâ˼:Ò»ÖÖ·½·¨ÊÇÀûÓñ¸·ÝÎļþ½øÐл¹Ô­;Ò»ÖÖ·½·¨ÊÇÀûÓÃÊý¾ÝÎļþ½øÐи½¼Ó»¹Ô­.
    ÎÒÃÇÏÈÀ´¿´±¸·Ý»¹Ô­µÄ·½Ê½:
            Èç¹ûÊÇÓÃ2005µÄÊý¾Ý¿âÔÚ2000Ï»¹Ô­,»á³öÏÖ´íÎó:
           Msg 3205, Level 16, State 2, Line 1
          Too many backup devices specified for backup or restore; only 64 are allowed.
          Msg 3013, Level 16, State 1, Line 1
          RESTORE DATABASE is terminating abnormally.
            Èç¹ûÊÇÓÃ2008µÄÊý¾Ý¿âÔÚ2005Ï»¹Ô­,»á³öÏÖ´íÎó:
            Msg 3241, Level 16, State 7, Line 1
           The media family on device 'c:\xxx.bak' is incorrectly formed.
           SQL Server cannot process this media family.
           Msg 3013, Level 16, State 1, Line 1
           RESTORE DATABASE is terminating abnormally.
   ½Ó×ÅÎÒÃÇÀ´¿´¸½¼Ó»¹Ô­µÄ·½Ê½:
 
            Èç¹ûÊÇÓÃ2005µÄÊý¾Ý¿âÔÚ2000ϸ½¼Ó»¹Ô­,»á³öÏÖ´íÎó:
 
             Msg 1813, Level 16, State 2, Line 1
            Could not


Ïà¹ØÎĵµ£º

SQL ¸½¼ÓÊý¾Ý¿âʱ³öÏÖ ÎÞ·¨´ò¿ªÎïÀíÎļþ´íÎó

SQL ¸½¼ÓÊý¾Ý¿âʱ³öÏÖ ÎÞ·¨´ò¿ªÎïÀíÎļþ´íÎó
´íÎóÐÅÏ¢:
Ö´ÐÐ Transact-SQL Óï¾ä»òÅú´¦Àíʱ·¢ÉúÁËÒì³£¡£ (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ÎÞ·¨´ò¿ªÎïÀíÎļþ "D:\SqlDataBase\Test.mdf"¡£²Ù×÷ϵͳ´íÎó 5:"5(¾Ü¾ø·ÃÎÊ¡£)"¡£ (Microsoft SQL Server£¬´íÎó: 5120)
½â¾ö°ì·¨:
  ......

DB2µÄ³£ÓÃSQLС½á


1¡¢×éºÏÓï¾äÖ´ÐÐ
BEGIN   ATOMIC
±í´ïʽ1 ·ÖºÅ ¿Õ¸ñ/»Ø³µ
±í´ïʽ2 ·ÖºÅ ¿Õ¸ñ/»Ø³µ
END
2¡¢Ó¦¸ÃÏÞÖÆ·ÃÎÊȨÏÞµÄ±í£¨Ó¦¸Ã³·ÏúÕâЩ±íPUBLIC SELECT·ÃÎÊȨ£©
SYSCAT.DBAUTH
SYSCAT.TABAUTH
SYSCAT.PACKAGEAUTH
SYSCAT.INDEXAUTH
SYSCAT.COLAUTH
SYSCAT.PASSTHRUAUTH
SYSCAT.SCHEMAAUTH
±È½ÏÓÐÓõÄĿ¼± ......

sqlÊý¾Ý¿âµÄ¹Ø¼ü×Ö¼°²éѯ¼°º¯Êý

    ±¾ÖܺÍÉÏÖܾ­Àí¸øÎÒÃÇ×öÁËÁ½´Î¹ØÓÚsqlµÄÅàѵ£¬¸Ð¾õºÜÓÐÓÃËùÒÔ×ܽáһϣ¡
    Union£ºÖ»ÓÐÁ½Õűí½á¹¹ÏàͬµÄ½á¹û¼¯²ÅÄÜʹÓÃunion£¬½«ËùÓеıíÊý¾Ý·Åµ½Ò»¸ö½á¹û¼¯ÖС£
    Count£º¼ÆËã²ÎÊýÁбíÖеÄÊý×ÖÏîµÄ¸öÊý¡£À¨ºÅÀï±ß¿ÉÒÔÊÇÁÐÃû£¬Ò²¿ÉÒÔÊDzÎÊýÖµ¡£
    ......

SQL Server 2005ÆôÓÃsaÕ˺Å


SQL Server 2005ÆôÓÃsaÕ˺Å
ÆôÓÃsaÓû§ºÍÔ¶³ÌÁ¬½Ó 
²Ëµ¥Start->Microsoft SQL Server 2005->Configuration Tools->SQL Server Configuration Manager 
Ñ¡ÖÐSQL Server 2005 Network Configuration 
ÔÚÓұߵÄTCP/IPÉϵãÓÒ¼ü£¬enabled 
²Ëµ¥Start->Microsoft SQL Server 2005->SQL ......

50¸ö³£ÓõÄSQLÓï¾ä

Student(S#,Sname,Sage,Ssex) ѧÉú±í 
Course(C#,Cname,T#) ¿Î³Ì±í 
SC(S#,C#,score) ³É¼¨±í 
Teacher(T#,Tname) ½Ìʦ±í 
ÎÊÌ⣺ 
1¡¢²éѯ“001”¿Î³Ì±È“002”¿Î³Ì³É¼¨¸ßµÄËùÓÐѧÉúµÄѧºÅ£» 
select a.S# from (select s#,score from SC where C#='001') a,(sele ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ