Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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
±È½ÏÓÐÓõÄĿ¼± ......

oracle pl/sqlʵÀýÁ·Ï°


µÚÒ»²¿·Ö£ºoracle pl/sqlʵÀýÁ·Ï°(1)
Ò»¡¢Ê¹ÓÃscott/tigerÓû§ÏµÄemp±íºÍdept±íÍê³ÉÏÂÁÐÁ·Ï°£¬±íµÄ½á¹¹ËµÃ÷ÈçÏÂ
empÔ±¹¤±í(empnoÔ±¹¤ºÅ/enameÔ±¹¤ÐÕÃû/job¹¤×÷/mgrÉϼ¶±àºÅ/hiredateÊܹÍÈÕÆÚ/salн½ð/commÓ¶½ð/deptno²¿ÃűàºÅ)
dept²¿Ãűí(deptno²¿ÃűàºÅ/dname²¿ÃÅÃû³Æ/locµØµã)
¹¤×Ê £½ н½ð £« Ó¶½ð
Ò²¿ÉÒÔͨ¹ý ......

oracle dba ³£ÓÃsql語¾ä

³£ÓÃSQL²éѯ£º
 
1¡¢²é¿´±í¿Õ¼äµÄÃû³Æ¼°´óС
 
select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size
from dba_tablespaces t, dba_data_files d
where t.tablespace_name = d.tablespace_name
group by t.tablespace_name;
 
2¡¢²é¿´±í¿Õ¼äÎïÀíÎļþµÄÃû³Æ¼°´óС
 
select t ......

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

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