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

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


Ïà¹ØÎĵµ£º

.NETѧϰÊÖ¼ÇÖ®£ºlinq to SQL(Ò»)


Ò»¸ö¼òµ¥µÄÀý×Ó£º
ÏȽ¨Ò»¸öC#Àࣺ
ÒýÓÃSystem.Data.Linq.dll³ÌÐò¼¯£¬
using System.Data.Linq.MappingºÍ
using System.Data.Linq Á½¸ö¿Õ¼ä¡£
[Table]
public class Inventory
{
   [Column]
   public string Make;
   [Column]
   public string Color;
 &nbs ......

SQL×¢Èë

SQL×¢Èë¹¥»÷
¡¡¡¡SQL×¢Èë¹¥»÷ÊǺڿͶÔÊý¾Ý¿â½øÐй¥»÷µÄ³£ÓÃÊÖ¶ÎÖ®Ò»¡£Ëæ×ÅB/SģʽӦÓÿª·¢µÄ·¢Õ¹£¬Ê¹ÓÃÕâÖÖģʽ±àдӦÓóÌÐòµÄ³ÌÐòÔ±Ò²Ô½À´Ô½¶à¡£µ«ÊÇÓÉÓÚ³ÌÐòÔ±µÄˮƽ¼°¾­ÑéÒ²²Î²î²»Æë£¬Ï൱´óÒ»²¿·Ö³ÌÐòÔ±ÔÚ±àд´úÂëµÄʱºò£¬Ã»ÓжÔÓû§ÊäÈëÊý¾ÝµÄºÏ·¨ÐÔ½øÐÐÅжϣ¬Ê¹Ó¦ÓóÌÐò´æÔÚ°²È«Òþ»¼¡£Óû§¿ÉÒÔÌá½»Ò»¶ÎÊý¾Ý¿â²éѯ´ú ......

SQL ÓÅ»¯¼¼ÇÉ

1 ±ÜÃâÎ޼ƻ®µÄÈ«±íɨÃè
  ÈçÏÂÇé¿ö½øÐÐÈ«±íɨÃ裺
-          ¸Ã±íÎÞË÷Òý
-          ¶Ô·µ»ØµÄÐÐÎÞÈ˺ÍÏÞÖÆÌõ¼þ£¨ÎÞWhere×Ӿ䣩
-          ¶ÔÓÚË÷ÒýÖ÷ÁУ¨Ë÷ÒýµÄµÚÒ» ......

sql ·þÎñÆ÷½ÇÉ« Êý¾Ý¿â½ÇÉ«



sql ·þÎñÆ÷½ÇÉ« Êý¾Ý¿â½ÇÉ«
·þÎñÆ÷½ÇÉ«
ËùÓеķþÎñÆ÷½ÇÉ«¶¼ÊÇ“¹Ì¶¨µÄ”½ÇÉ«£¬²¢ÇÒ£¬´ÓÒ»¿ªÊ¼¾Í´æÔÚÓÚÄÇÀï——×Ô°²×°ÍêSQL ServerµÄÄÇÒ»¿ÌÆð£¬Ä㽫ӵÓеÄËùÓзþÎñÆ÷½ÇÉ«¾ÍÒѾ­´æÔÚÁË¡£

½Ç¡¡¡¡É«
ÌØ¡¡¡¡ÐÔ

sysadmin
¸Ã½ÇÉ«Äܹ»Ö´ÐÐSQL ServerÉϵÄÈκβÙ× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ