SQL Server ϵͳȫ¾Ö±äÁ¿
SQL Server ϵͳȫ¾Ö±äÁ¿
@@CONNECTIONS
·µ»Ø×ÔÉÏ´ÎÆô¶¯ÒÔÀ´Á¬½Ó»òÊÔͼÁ¬½ÓµÄ´ÎÊý¡£
@@CURSOR_ROWS
·µ»ØÁ¬½ÓÉÏ×îºó´ò¿ªµÄÓαêÖе±Ç°´æÔڵĺϸñÐеÄÊýÁ¿(·µ»Ø±»´ò¿ªµÄÓαêÖл¹Î´±»¶ÁÈ¡µÄÓÐЧÊý¾ÝÐеÄÐÐÊý)
@@DATEFIRST
·µ»ØÿÖܵÚÒ»ÌìµÄÊý×Ö
@@ERROR
·µ»Ø×îºóÖ´ÐеÄSQL Óï¾äµÄ´íÎó´úÂë¡£
@@FETCH_STATUS
·µ»Ø±» FETCH Óï¾äÖ´ÐеÄ×îºóÓαêµÄ״̬£¬¶ø²»ÊÇÈκε±Ç°±»Á¬½Ó´ò¿ªµÄÓαêµÄ״̬¡£
@@IDENTITY
·µ»Ø×îºó²åÈëµÄ±êʶֵ
@@LANGID
·µ»Øµ±Ç°ËùʹÓÃÓïÑԵı¾µØÓïÑÔ±êʶ·û(ID)¡£
@@LANGUAGE
·µ»Øµ±Ç°Ê¹ÓõÄÓïÑÔÃû¡£
@@LOCK_TIMEOUT
·µ»Øµ±Ç°»á»°µÄµ±Ç°Ëø³¬Ê±ÉèÖ㬵¥Î»ÎªºÁÃë¡£
@@PROCID
·µ»Øµ±Ç°¹ý³ÌµÄ´æ´¢¹ý³Ì±êʶ·û (ID) ¡£
@@ROWCOUNT
·µ»ØÊÜÉÏÒ»Óï¾äÓ°ÏìµÄÐÐÊý¡£
@@SERVERNAME
·µ»ØÔËÐÐ µÄ±¾µØ·þÎñÆ÷Ãû³Æ¡£
@@SPID
·µ»Øµ±Ç°Óû§½ø³ÌµÄ·þÎñÆ÷½ø³Ì±êʶ·û (ID)¡£
@@TRANCOUNT
·µ»Øµ±Ç°Á¬½ÓµÄ»î¶¯ÊÂÎñÊý¡£
@@VERSION
·µ»Øµ±Ç°°²×°µÄÈÕÆÚ¡¢°æ±¾ºÍ´¦ÀíÆ÷ÀàÐÍ¡£
@@CPU_BUSY
·µ»Ø×ÔSQL Server ×î½üÒ»´ÎÆô¶¯ÒÔÀ´CPU µÄ¹¤×÷ʱ¼äÆ䵥λΪºÁÃë
@@DATEFIRST
·µ»ØʹÓÃSET DATEFIRST ÃüÁî¶ø±»¸³ÖµµÄDATAFIRST ²ÎÊýÖµSET DATEFIRST£¬ÃüÁîÓÃÀ´Ö¸¶¨Ã¿ÖܵĵÚÒ»ÌìÊÇÐÇÆÚ¼¸
@@DBTS
·µ»Øµ±Ç°Êý¾Ý¿âµÄʱ¼ä´ÁÖµ±ØÐë±£Ö¤Êý¾Ý¿âÖÐʱ¼ä´ÁµÄÖµÊÇΩһµÄ
@@ERROR
·µ»ØÖ´ÐÐTransact-SQL Óï¾äµÄ´íÎó´úÂë
@@FETCH_STATUS
·µ»ØÉÏÒ»´ÎFETCH Óï¾äµÄ״ֵ̬
@@IDLE
·µ»Ø×ÔSQL Server ×î½üÒ»´ÎÆô¶¯ÒÔÀ´CPU ´¦ÓÚ¿Õ±Õ״̬µÄʱ¼ä³¤¶Ìµ¥Î»ÎªºÁÃë
@@IO_BUSY
·µ»Ø×ÔSQL Server ×î½üÒ»´ÎÆô¶¯ÒÔÀ´CPU Ö´ÐÐÊäÈëÊä³ö²Ù×÷Ëù»¨·ÑµÄʱ¼äÆ䵥λΪºÁÃë
@@LANGID
·µ»Øµ±Ç°ËùʹÓõÄÓïÑÔID Öµ
@@LANGUAGE
·µ»Øµ±Ç°Ê¹ÓõÄÓïÑÔÃû³Æ
@@LOCK_TIMEOUT
·µ»Øµ±Ç°»á»°µÈ´ýËøµÄʱ¼ä³¤¶ÌÆ䵥λΪºÁÃë
@@MAX_CONNECTIONS
·µ»ØÔÊÐíÁ¬½Óµ½SQL Server µÄ×î´óÁ¬½ÓÊýÄ¿
@@MAX_PRECISION
·µ»Ødecimal ºÍnumeric Êý¾ÝÀàÐ͵ľ«È·¶È
@@NESTLEVEL
·µ»Øµ±Ç°Ö´ÐеĴ洢¹ý³ÌµÄǶÌ×¼¶Êý³õʼֵΪ0
@@OPTIONS
·µ»Øµ±Ç°SET Ñ¡ÏîµÄÐÅÏ¢
@@PACK_RECEIVED
·µ»ØSQL Server ͨ¹ýÍøÂç¶ÁÈ¡µÄÊäÈë°üµÄÊýÄ¿
@@PACK_SENT
·µ»ØSQL Server д¸øÍøÂçµÄÊä³ö°üµÄÊýÄ¿
@@PACKET_ERRORS
·µ»ØÍøÂç°üµÄ´íÎóÊýÄ¿
@@PROCID
·µ»Øµ±Ç°´æ´¢¹ý³ÌµÄID Öµ
@@REMSERVER
·µ»ØÔ¶³ÌSQL Server Êý¾Ý¿â·þÎñÆ÷µÄÃû³Æ
@@SERVICENAME
·µ»ØSQL Server ÕýÔËÐÐÓÚÄÄÖÖ·þÎñ״̬֮ÏÂÈçMSSQLServe
Ïà¹ØÎĵµ£º
Ò»¡¢´´½¨Ò»¸ö¼òµ¥µÄ´¥·¢Æ÷
´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì£¬ÀàËÆÓÚʼþº¯Êý£¬SQL Server? ÔÊÐíΪ INSERT¡¢UPDATE¡¢DELETE ´´½¨´¥·¢Æ÷£¬¼´µ±ÔÚ±íÖвåÈë¡¢¸üС¢É¾³ý¼Ç¼ʱ£¬´¥·¢Ò»¸ö»òһϵÁÐ T-SQLÓï¾ä¡£
´¥·¢Æ÷¿ÉÒÔÔÚ²éѯ·ÖÎöÆ÷Àï´´½¨£¬Ò²¿ÉÒÔÔÚ±íÃûÉϵãÓÒ¼ü->“ËùÓÐÈÎÎñ”->“¹ÜÀí´¥·¢Æ÷”À´´´½¨ ......
ͬ²½Ò»ÏÂÎÒbaiduµÄblog£ºhttp://hi.baidu.com/ncheng/blog/item/bc65f82a1a6a7c335343c11c.html
Sql×¢ÈëÊÇÒ»ÖÖÈëÃż«µÍÆÆ»µ¼«´óµÄ¹¥»÷·½Ê½¡£Èç¹ûsqlÊÇÓÃ×Ö·û´®Æ´½Ó³öÀ´µÄ»°£¬ÄÇô¿Ï¶¨»á±»×¢Èë¹¥»÷£¬Ç°¶Îʱ¼ä»¹´«³öÁËij¹úÍâ´óÐÍÉç½»ÍøÕ¾±»SQL×¢Èë¹¥»÷¡£
Sql×¢Èë¹¥»÷µÄ·½Ê½£¬À´ÕâÀï¿´µÄͬ־ÃÇÓ¦¸ÃºÜÇå³þÁË£¬¾ÍÊÇÔÚÆ´½Ó×Ö·û´ ......
ÉÏһƪдµÄsql×¢ÈëµÄ»ù±¾ÔÀí£¬±¾À´Òª½Ó×ÅдÕâƪµÄ£¬µ«ÊÇÓÉÓÚʱ¼äµÄÔÒòһֱûÓÐд³É£¬½ñÌìÊÇÎåÒ»¼ÙÆÚ£¬×ÜËãÊÇÄܳé¿ÕддÁË¡£
×÷Ϊһ¸ö³ÌÐòÔ±£¬·À·¶sql×¢ÈëµÄµÚÒ»ÏßÊÇÓÉÎÒÃÇÀ´ÊØ»¤µÄ£¬Ö»ÒªÎÒÃÇÔÚ³ÌÐòÖÐÁôÉÙÐíµÄ©¶´£¬¾Í»á¸ø³ÌÐòÔöÇ¿°²È«ÌØÐÔ¡£ËùÒÔÎÒÃÇÒª×öµÄÊÇҪд°²È«µÄ³ÌÐò£¬·ÀÖ¹sql×¢ÈëÔÚ³ÌÐòÌåÏÖÔÚ²»ÒªÆ´½Ósql×Ö·û´®£¬ ......
ÊÓͼ
SET¡¡NOCOUNT ON;
SET Northwind;
GO
IF OBJECT_ID('dbo.ViewName') IS NOT NULL
DROP VIEW dbo.ViewName;
GO
CREATE VIEW dbo.Viewname
AS
SELECT * from customer AS C
WHERE EXISTS
(SELECT * from dbo.Orders AS O
WHERE O.CustomerI ......