SQL server 2005ѧϰ±Ê¼Ç(ÊÓͼ)
Ò»£®ÊÓͼ(VIEW)
¶¨Ò壺ÊÓͼÊÇÒ»ÕÅÐéÄâµÄ±í£¬ÆäÄÚÈÝÊÇ´ÓÒ»ÕÅ»ò¶àÕűíÖвéѯµÃÀ´µÄ½á¹û¼¯¡£
ÃèÊö£ºÊÓͼÊÇ´æ´¢ÔÚϵͳĿ¼ÖеÄÐÅÏ¢£¬Ëý²¢Ã»ÓÐÕæÕý´æ´¢Êý¾Ý£¬¶øÊÇÒÑ´æ±íµÄͶӰ¡£ÊÓͼµÄÊôÐÔÊÇ°´ÕÕÒ»¸ö²éѯµÄ¹æ¶¨´ÓÒ»¸ö»òÕ߶à¸ö±íÖе¼³öµÄ£¬ÊÇÒÑ´æ±íµÄ¹ýÂËÆ÷¡£ËýÊÇÒ»ÕÅ“Ðé±í”£¬´ÓÒ»Õűí»òÕ߶àÕűíÖÐÅÉÉú³öÀ´µÄ£¬ÆäÀ´Ô´³ÆΪ“»ù±í”£¬Ò²¿ÉÒÔ˵ÊÓͼÊÇÒ»ÕÅ“ÅÉÉú±í”¡£
×÷ÓãºÓû§¸ü¾ß×Ô¼ºÐèÒª£¬½¨Á¢ÊÓͼ¡£ÕâÑù¾Í¹ýÂ˵ôÁËÄÇЩ²»³£ÓûòÕßÓû§²»ÐèÒªµÄÊý¾Ý£¬ÈÃÓû§µÄ²Ù×÷¸ü¼ÓѸËÙ¡£ÆäÓŵ㣺
1.½µµÍÊý¾Ý¿âµÄ¸´ÔÓÐÔ¡£
2.¼¯ÖÐÓû§Êý¾Ý¡£
3.¼òµ¥¹ÜÀí¡£
4.×éÖ¯Êý¾ÝתÒƵ½ÆäËûÓ¦ÓóÌÐò¡£
5.Êý¾Ý±£ÃÜ¡£
¶þ£®ÊÓͼ½¨Á¢
CREATE VIEW <ÊÓͼÃû> [(<ÁÐÃû>[,<ÁÐÃû>]......)]
AS <×Ó²éѯ>
[WITH CHECK OPTION]
×Ó²éѯ¿ÉÒÔÊÇÈÎÒ⸴ÔÓµÄSELECTÓï¾ä£¬µ«ÊÇ×Ó²éѯÖв»ÄÜ°üÀ¨ORDER BYºÍDISTINCTÓï¾ä¡£
WITH CHECK OPTION ±íʾ¶ÔÊÓͼ½øÐÐUPTATA£¬INSERTºÍDELETE²Ù×÷ʱҪ±£Ö¤¸üС¢²åÈëºÍɾ³ýµÄÐÐÂú×ãÊÓͼ¶¨ÒåÖеÄΪ´ËÌõ¼þ(¼´×Ó²éѯÖеıí´ïʽ)¡£
Èý£®ÊÓͼ¹ÜÀí
1£®ÖØÃüÃûÊÓͼ
ʵÏÖ·½Ê½ÓÐÁ½ÖÖ£º
(1)ͨ¹ý sp_name
¸ñʽ£ºsp_name <ÔÊÓͼÃû>,<ÐÂÊÓͼÃû>
×¢Ò⣺´Ë²Ù×÷±ØÐëÔÚµ±Ç°Êý¾Ý¿âÖУ¬Ö»ÓÐÊý¾Ý¿âÓµÓÐÕߺ͹ÜÀíÕß²ÅÄܶÔÊÓͼ¸üÃû¡£
(2)ͨ¹ý¹ÜÀíÆ÷½øÐиüÃû¡£
2.ÊÓͼÐÞ¸Ä
¸ñʽ£º
ALTER VIEW <ÊÓͼÃû>
AS
SELECT ²éѯÓï¾ä
[WITH CHECK OPTION]
3.ɾ³ýÊÓͼ
¸ñʽ£º
DROP VIEW <ÊÓͼÃû>
×¢Ò⣺ÔÚɾ³ýÊÓͼºó£¬´ÓÕâ¸öÊÓͼÅÉÉú³öÀ´µÄÊÓͼ×Ô¶¯É¾³ý£¬µ«É¾³ýij¸ö±íºó£¬»ùÓÚÕâ¸ö±í´´½¨µÄÊÓͼ²»ÄÜ×Ô¶¯É¾³ý¡£
ËÄ£®ÊÓͼӦÓÃ
ÊÓͼӦÓõÄÔ¼Êø£¬ÏÂÁÐÇé¿öϲ»ÄܶÔÊÓͼ½øÐвÙ×÷£º
1.ÊÓͼÊôÐÔÀ´×Ô¾Û¼¯º¯Êý»òÕß°üº¬±í´ïʽ¡¢³£Á¿¡£
2.ÊÓÍ
Ïà¹ØÎĵµ£º
¿ªÆô¸÷ÖÖ·þÎñ
@NET stop SQLSERVERAGENT
@NET stop MSSQLServerOLAPService
@NET stop msftesql
@NET stop MsDtsServer
@NET stop SQLWriter
  ......
SQL Server 2000ÖУ¬ÓÐÈý¸ö±È½ÏÀàËƵŦÄÜ£ºËûÃÇ·Ö±ðÊÇ£ºSCOPE_IDENTITY¡¢IDENT_CURRENT ºÍ @@IDENTITY£¬ËüÃǶ¼·µ»Ø²åÈëµ½ IDENTITY ÁÐÖеÄÖµ¡£
IDENT_CURRENT ·µ»ØΪÈκλỰºÍÈκÎ×÷ÓÃÓòÖеÄÌض¨±í×îºóÉú³ÉµÄ±êʶֵ¡£IDENT_CURRENT ²»ÊÜ×÷ÓÃÓòºÍ»á»°µÄÏÞÖÆ£¬¶øÊÜÏÞÓÚÖ¸¶¨µÄ±í¡£IDENT_CURRENT ·µ»ØΪÈκλỰºÍ×÷ÓÃÓòÖÐµÄ ......
select t.OSUSER,t.STATUS,t.LOGON_TIME from v$session t
select t.OSUSER,t.STATUS,t.LOGON_TIME from v$session t where t.OSUSER='admin'
select t.OSUSER,t.STATUS,t.LOGON_TIME from v$session t where t.OSUSER='liuzhaoqing'
select t.OSUSER,t.STATUS,t.LOGON_TIME from v$session t where t.OSUSER='ymx'
sel ......
Ê×ÏÈÆô¶¯SQL SERVERµÄ·þÎñ
Á¬½Óºó ÔÚÊý¾Ý¿âÉÏÓÒ¼ü
Ñ¡Ôñ¸½¼Ó¡£¡£¡£
µã»÷ Ìí¼Ó¡£¡£¡£
ÔÚÌø³ö¿òÄÚÕÒµ½ÄãµÄMDFÎļþλÖà ѡÖÐ Ìí¼Ó½øÈ¥
ÏàͬÎļþ¼ÐÄÚµÄLDFÎļþ×Ô¶¯¼ÓÉÏ
Íê³É~~(*^__^*) ÎûÎû……
OKÀ² ºÇºÇ
³õѧ³õѧ~Ï£ÍûÒ²ÄÜ°ïµ½ÆäËûÏñÎÒÒ»ÑùµÄ³õѧÕß
´ó¼ÒÒ»Æð¼ÓÓÍ°É£¡O(∩_∩)O~ ......