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

SQL±¸·ÝÓ뻹ԭ¾­µäÎĵµ

SQL±¸·ÝÓ뻹ԭ¾­µäÎĵµ
======================================================================
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
----------------------------------------------------------------------
2¡¢±¸·ÝÉ豸
----------------------------------------------------------------------
1£©ÎïÀíÉ豸
---------------------------
disk£ºÖ§³Ö±¾µØ´ÅÅÌ»òÕßÍøÂ籸·Ý
tape£ºÖ§³Ö´Å´ø»ú±¸·Ý
name pipe£ºÖ§³ÖµÚÈý·½±¸·ÝÈí¼þ
---------------------------
2£©Âß¼­É豸
---------------------------
ÓÀ¾Ã±¸·ÝÎļþ£º¿ÉÒÔÖØ¸´Ê¹Óã¬Ó¦¸ÃÔÚ±¸·Ýǰ´´½¨¡£
ÁÙʱ±¸·ÝÎļþ£ºÓÃÓÚÒ»´ÎÐÔ±¸·Ý£¬ÔÚ±¸·Ýʱ´´½¨¡£
-------------------------------------------------
exec sp_addumpde


Ïà¹ØÎĵµ£º

¾­µäSQLÓï¾ä´óÈ«

ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
¡¡¡¡SQL·ÖÀࣺ
¡¡¡¡DDL—Êý¾Ý¶¨ÒåÓïÑÔ
(CREATE£¬ALTER£¬DROP£¬DECLARE)
¡¡¡¡DML—Êý¾Ý²Ù×ÝÓïÑÔ
(SELECT£¬DELETE£¬UPDATE£¬INSERT)
¡¡¡¡DCL—Êý¾Ý¿ØÖÆÓïÑÔ
(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
¡¡¡¡Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
¡¡¡¡1¡¢ËµÃ÷£º´´½¨Êý ......

SQL Server Ë÷Òý½á¹¹¼°ÆäʹÓã¨Ò»£©

SQL Server Ë÷Òý½á¹¹¼°ÆäʹÓã¨Ò»£©
×÷Õߣºfreedk
Ò»¡¢ÉîÈëdz³öÀí½âË÷Òý½á¹¹
¡¡¡¡Êµ¼ÊÉÏ£¬Äú¿ÉÒÔ°ÑË÷ÒýÀí½âΪһÖÖÌØÊâµÄĿ¼¡£Î¢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý£¨clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý£©ºÍ·Ç¾Û¼¯Ë÷Òý£¨nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý£©¡£ÏÂÃæ£¬ÎÒÃǾÙÀýÀ´ËµÃ÷һϾۼ¯Ë÷ ......

SQL Server Ë÷Òý½á¹¹¼°ÆäʹÓ㨶þ£©

SQL Server Ë÷Òý½á¹¹¼°ÆäʹÓ㨶þ£©
×÷Õߣºfreedk
Ò»¡¢ÉîÈëdz³öÀí½âË÷Òý½á¹¹
¸ÄÉÆSQLÓï¾ä
¡¡¡¡ºÜ¶àÈ˲»ÖªµÀSQLÓï¾äÔÚSQL SERVERÖÐÊÇÈçºÎÖ´Ðеģ¬ËûÃǵ£ÐÄ×Ô¼ºËùдµÄSQLÓï¾ä»á±»SQL SERVERÎó½â¡£±ÈÈ磺
select * from table1 where name=''zhangsan'' and tID > 10000
ºÍÖ´ÐÐ:
select * from table1 where tID ......

ÈçºÎÐÞ¸ÄSQL SAÃÜÂë

1>ͨ¹ýÆóÒµ¹ÜÀíÆ÷½øÈë²éѯ·ÖÎöÖ´ÐУº
EXEC sp_password NULL, 'ÄãµÄÐÂÃÜÂë', 'sa'
Èç¹ûÄãÔÚNTÏÂ(°üÀ¨2000)×°µÄSQL Server£¬Ôò¿ÉÒÔÕâÑù×ö£º
Ö±½Ó´ò¿ª"²éѯ·ÖÎöÆ÷"(×¢Òâ²»ÊÇ´Ó"ÆóÒµ¹ÜÀíÆ÷"ÖнøÈë,¿ÉÒÔ´Ó¿ªÊ¼²Ëµ¥µÄ³ÌÐò×é½øÈ¥,Èç¹ûÕÒ²»µ½µÄ»°,Ö±½ÓÔÚ"ÔËÐÐ"ÖÐÊäÈë"isqlw.exe"Ò²¿É);
Ñ¡Ôñ"WindowsÉí·ÝÑéÖ¤"½øÈë,²»ÐèÒªÊäÈ ......

SQLʱ¼äº¯ÊýÏêϸ˵Ã÷

1. µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
select getdate()
2. dateadd ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
ÀýÈ磺ÏòÈÕÆÚ¼ÓÉÏ2Ìì
select dateadd(day,2,'2004-10-15') --·µ»Ø£º2004-10-17 00:00:00.000
3. datediff ·µ»Ø¿çÁ½¸öÖ¸¶¨ÈÕÆÚµÄÈÕÆÚºÍʱ¼ä±ß½çÊý¡£
select datediff(day,'2004-09-01','2004-09-18') --· ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ