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µÝ¹é²éѯµÄ.²»¶®,ÓÚÊǵ½csdnÉÏÈ¥ÎÊ,ÄÇÀïµÄЧÂÊÕæÊǷdz£¸ß,ÎÒÒÔǰҲûÔÚÉÏÃæÎʹýÎÊÌâ.
ÎÊÌâÃèÊö:
ÎÒÓÐÒ»¸ö±í½á¹¹ÈçÏÂ:
id upperid
1 2
3 2
4 1
5 3
¾ßÌå²ã´Î²»ÖªµÀ,ÎÒÏëÓõݹésqlÓ ......
//tree.aspx.cs
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Syst ......
create table students (
name varchar(25),
class varchar(25),
grade int
)
insert into students values ('ÕÅÈý','ÓïÎÄ',20)
insert into students values ('ÕÅÈý','Êýѧ',90)
insert into students values ('ÕÅÈý','Ó¢Óï',50)
insert into students values ('ÀîËÄ','ÓïÎÄ',81)
insert in ......
ÓеÄʱºòÎÒÃÇÐèÒªÒ»´ÎÏñÊý¾Ý¿âÖÐÌí¼Ó¶àÌõ¼Ç¼£¬ÎÒÃÇ¿ÉÒÔʹÓÃÏÂÃæµÄÓï¾äÀ´ÊµÏÖ£º
--Ìí¼ÓÒ»Ìõ¼Ç¼
INSERT INTO tableName(col1,col2,col3) VALUES (1,2,3)
--Ìí¼Ó¶àÌõ¼Ç¼
INSERT INTO tableName(col1,col2,col3)
SELECT 3,4,5
UNION ALL
SELECT 6,7,8
--´ÓÁíÍâµÄÒ»ÕűíÖжÁÈ¡¶àÌõÊý¾ÝÌí¼Óµ½Ð±íÖÐ
INSERT INTO tabl ......
ÏÂÃæÊDzÙ×÷²½Ö裺
1. “·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÓ -¡·“±¾µØÁ¬½ÓºÍÔ¶³ÌÁ¬½Ó”-¡·“ͬʱʹÓÃTCP/IPºÍNamed Pipes“£»
2. “·þÎñÅäÖùÜÀíÆ÷”-¡·“ÍøÂçÅäÖÔ-¡·“SQL ExpressµÄÐÒé“-¡·“IPµØÖ·”£¬½«IpAll Tcp¶Ë¿Ú¸ÄΪ1433£»
3. ÖØÆô·þ ......