SQLÊý¾Ý¿â»Ö¸´Ä£ÐÍ(ÈÕÖ¾)
----------------------------------------------------------------------
1¡¢SQLÊý¾Ý¿â»Ö¸´Ä£ÐÍ
----------------------------------------------------------------------
1£©ÍêÈ«»Ö¸´Ä£ÐÍ
-----------------
£¨1£©±¸·ÝʱҪ±¸·ÝÊý¾Ý¿âµÄÊý¾ÝÎļþºÍÈÕÖ¾Îļþ
£¨2£©»¹ÔʱʹÓÃÊý¾Ý¿âµÄ±¸·ÝµÄÊý¾ÝÎļþ¸±±¾ºÍÈ«²¿ÈÕÖ¾ÐÅÏ¢À´»Ö¸´Êý¾Ý¿â¡£
£¨3£©ÄÜ»¹ÔÈ«²¿Êý¾Ý£¬²¢¿ÉÒÔ½«Êý¾Ý¿â»Ö¸´µ½ÈÎÒâÖ¸¶¨µÄʱ¿Ì¡£
£¨4£©Îª±£Ö¤ÊµÏÖ¼´Ê±µã»Ö¸´£¬¶ÔÊý¾Ý¿âµÄËùÓÐ*×÷¶¼½«ÍêÕûµØ¼ÇÈëÈÕÖ¾£¬ÕâÑù£¬ÈÕÖ¾Õ¼Óÿռä½Ï´ó£¬¶ÔÐÔÄÜÒ²ÓÐËùÓ°Ïì¡£
------------------
£¨2£©´óÈÝÁ¿ÈÕÖ¾¼Ç¼»Ö¸´Ä£ÐÍ
------------------
£¨1£©±¸·ÝʱҪ±¸·ÝÊý¾Ý¿âµÄÊý¾ÝÎļþºÍÈÕÖ¾Îļþ
£¨2£©»¹ÔʱʹÓÃÊý¾Ý¿âµÄ±¸·ÝµÄÊý¾ÝÎļþ¸±±¾ºÍÈ«²¿ÈÕÖ¾ÐÅÏ¢À´»Ö¸´Êý¾Ý¿â¡£
£¨3£©ÈÕÖ¾Öв»¼Ç¼*×÷ϸ½Ú£¨Èçselect into¡¢create indexµÈ£©£¬¶øÖ»¼Ç¼*×÷µÄ×îÖÕ½á¹û£¬Òò´ËÕ¼ÓÃÈÕÖ¾¿Õ¼äС¡£
£¨4£©Ö»Ö§³Ö½«Êý¾Ý¿â»¹Ôµ½ÊÂÎñÈÕÖ¾±¸·ÝµÄʱ¿Ì£¬¶ø²»Ö§³Ö¼´Ê±µã»Ö¸´£¬Òò´Ë¿ÉÄܲúÉúÊý¾Ý¶ªÊ§¡£
-------------------
£¨3£©¼òµ¥»Ö¸´Ä£ÐÍ
-------------------
£¨1£©±¸·Ýʱֻ±¸·ÝÊý¾ÝÎļþ£¬»¹ÔʱҲÓñ¸·ÝµÄÊý¾ÝÎļþ»Ö¸´Êý¾Ý¿â¡£
£¨2£©Ö»Äܽ«Êý¾Ý»Ö¸´µ½Êý¾ÝÎļþ±¸·ÝµÄʱ¿Ì£¬¿ÉÄܲúÉú×î¶àµÄÊý¾Ý¶ªÊ§¡£
£¨3£©²»ÊÊÓÚÉú²úϵͳºÍ´ó¹æÄ£*×÷»·¾³ÏÂÑ¡Óá£
-----------------------------------------
alter database d1 set recovery simple--ÉèÖÃÊý¾Ý¿â»Ö¸´Ä£ÐÍ
alter database d1 set recovery bulk_logged
alter database d1 set recovery full
----------------------------------------------------------------------
ÔÚSQL ServerÖУ¬³ýÁËϵͳÊý¾Ý¿âÍ⣬Äã´´½¨µÄÿһ¸öÊý¾Ý¿â¶¼ÓÐÈýÖֿɹ©Ñ¡ÔñµÄ»Ö¸´Ä£ÐÍ: Simple(¼òµ¥), full(ÍêÕû), bulk-logged(ÅúÁ¿ÈÕÖ¾)¡£ ÏÂÃæÕâÌõÓï¾ä¿ÉÒÔÏÔʾ³öËùÓÐÔÚÏßÊý¾Ý¿âµÄ»Ö¸´Ä£ÐÍ:
SELECT name, (SELECT DATABASEPROPERTYEX(name, 'RECOVERY')) RecoveryModel from master..sysdatabases ORDER BY name
SQL Server 2005¼°ÒÔÉÏ°æ±¾Ò²¿ÉÒÔʹÓÃÏÂÃæÕâÌõÓï¾äÀ´²é¿´:
SELECT name, recovery_model_desc from master.sys.databases ORDER BY name
Èç¹ûÏë¸Ä±äÊý¾Ý¿âµÄ»Ö¸´Ä£ÐÍ£¬¿ÉÒÔʹÓÃÏÂÃæSQLÓï¾ä:
¼òµ¥»Ö¸´Ä£ÐÍ:ALTER DATABASE AdventureWorks SET RECOVERY SIMPLE
ÍêÕû»Ö¸´Ä£ÐÍ:ALTER DATABASE AdventureWorks SET RECOVERY FULL
ÅúÁ¿ÈÕÖ¾»Ö¸´Ä£ÐÍ:ALTER DA
Ïà¹ØÎĵµ£º
SQL×¢Èë¹¥»÷
¡¡¡¡SQL×¢Èë¹¥»÷ÊǺڿͶÔÊý¾Ý¿â½øÐй¥»÷µÄ³£ÓÃÊÖ¶ÎÖ®Ò»¡£Ëæ×ÅB/SģʽӦÓÿª·¢µÄ·¢Õ¹£¬Ê¹ÓÃÕâÖÖģʽ±àдӦÓóÌÐòµÄ³ÌÐòÔ±Ò²Ô½À´Ô½¶à¡£µ«ÊÇÓÉÓÚ³ÌÐòÔ±µÄˮƽ¼°¾ÑéÒ²²Î²î²»Æ룬Ï൱´óÒ»²¿·Ö³ÌÐòÔ±ÔÚ±àд´úÂëµÄʱºò£¬Ã»ÓжÔÓû§ÊäÈëÊý¾ÝµÄºÏ·¨ÐÔ½øÐÐÅжϣ¬Ê¹Ó¦ÓóÌÐò´æÔÚ°²È«Òþ»¼¡£Óû§¿ÉÒÔÌá½»Ò»¶ÎÊý¾Ý¿â²éѯ´ú ......
1 ±ÜÃâÎ޼ƻ®µÄÈ«±íɨÃè
ÈçÏÂÇé¿ö½øÐÐÈ«±íɨÃ裺
- ¸Ã±íÎÞË÷Òý
- ¶Ô·µ»ØµÄÐÐÎÞÈ˺ÍÏÞÖÆÌõ¼þ£¨ÎÞWhere×Ӿ䣩
- ¶ÔÓÚË÷ÒýÖ÷ÁУ¨Ë÷ÒýµÄµÚÒ» ......
--3.3.1 ʹÓÃÓα귨½øÐÐ×Ö·û´®ºÏ²¢´¦ÀíµÄʾÀý¡£
--´¦ÀíµÄÊý¾Ý
CREATE TABLE tb(col1 varchar(10),col2 int)
INSERT tb SELECT 'a',1
UNION ALL SELECT 'a',2
UNION ALL SELECT 'b',1
UNION ALL SELECT 'b',2
UNION ALL SELECT 'b',3
--ºÏ²¢´¦Àí
--¶¨Òå½á¹û¼¯±í±äÁ¿
DECLARE @t TABLE(col1 varchar(10),col2 varch ......
Êý¾Ý¿âÃæÊÔ³£ÓòâÊÔÌâ(SQL Server)
ÌâÄ¿1
¡¡¡¡ÎÊÌâÃèÊö:
¡¡¡¡Îª¹ÜÀí¸ÚλҵÎñÅàѵÐÅÏ¢£¬½¨Á¢3¸ö±í:
¡¡¡¡S (S#,SN,SD,SA) S#,SN,SD,SA ·Ö±ð´ú±íѧºÅ¡¢Ñ§Ô±ÐÕÃû¡¢ËùÊôµ¥Î»¡¢Ñ§Ô±ÄêÁä
¡¡¡¡C (C#,CN ) C#,CN ·Ö±ð´ú±í¿Î³Ì±àºÅ¡¢¿Î³ÌÃû³Æ
¡¡¡¡SC ( S#,C#,G ) S#,C#,G ·Ö±ð´ú±íѧºÅ¡¢ËùÑ¡Ð޵Ŀγ̱àºÅ¡¢Ñ§Ï°³É¼¨
¡¡¡¡1. Ê¹Ó ......