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

Àí½â SQL Server ÖÐϵͳ±íSysobjects

×ÜÓû§±í:select count(*) ×ܱíÊý from sysobjects where xtype='u'
×ÜÓû§±íºÍϵͳ±í:select count(*) ×ܱíÊý from sysobjects where xtype in('u','s')
×ÜÊÓͼÊý:select count(*) ×ÜÊÓͼÊý from sysobjects where xtype='v'
×Ü´æ´¢¹ý³ÌÊý:select count(*) ×Ü´æ´¢¹ý³ÌÊý from sysobjects where xtype='p'
×Ü´¥·¢Æ÷Êý:select count(*) ×Ü´¥·¢Æ÷Êý from sysobjects where xtype='tr'
¹ØÓÚSQL ServerÊý¾Ý¿âµÄÒ»ÇÐÐÅÏ¢¶¼±£´æÔÚËüµÄϵͳ±í¸ñÀï¡£ÎÒ»³ÒÉÄãÊÇ·ñ»¨¹ý±È½Ï¶àµÄʱ¼äÀ´¼ì²éϵͳ±í¸ñ£¬ÒòΪÄã×ÜÊÇæÓÚÓû§±í¸ñ¡£µ«ÊÇ£¬Äã¿ÉÄÜÐèҪż¶û×öÒ»µã²»Í¬Ñ°³£µÄÊ£¬ÀýÈçÊý¾Ý¿âËùÓеĴ¥·¢Æ÷¡£Äã¿ÉÒÔÒ»¸öÒ»¸öµØ¼ì²é±í¸ñ£¬µ«ÊÇÈç¹ûÄãÓÐ500¸ö±í¸ñµÄ»°£¬Õâ¿ÉÄÜ»áÏûºÄÏ൱´óµÄÈ˹¤¡£
Õâ¾ÍÈÃSysobjects±í¸ñÓÐÁËÓÃÎäÖ®µØ¡£ËäÈ»ÎÒ²»½¨ÒéÄã¸üÐÂÕâ¸ö±í¸ñ£¬µ«ÊÇÄ㵱ȻÓÐȨ¶ÔÆä½øÐÐÉó²é¡£
ÔÚ´ó¶àÊýÇé¿öÏ£¬¶ÔÄã×îÓÐÓõÄÁ½¸öÁÐÊÇSysobjects.nameºÍSysobjects.xtype¡£Ç°ÃæÒ»¸öÓÃÀ´Áгö´ý¿¼²ì¶ÔÏóµÄÃû×Ö£¬¶øºóÒ»¸öÓÃÀ´¶¨Òå¶ÔÏóµÄÀàÐÍ
type ÀàÐÍö¾ÙÖµÈçÏ£º
AF = ¾ÛºÏº¯Êý(CLR)
C = ¼ì²éÔ¼Êø
D = ĬÈÏÖµ»ò DEFAULT Ô¼Êø
F = FOREIGN KEY Ô¼Êø
PK = PRIMARY KEY Ô¼Êø£¨ÀàÐÍÊÇ K£©
P = SQL´æ´¢¹ý³Ì
PC = ³ÌÐò¼¯(CLR)´æ´¢¹ý³Ì
FN = SQL±êÁ¿º¯Êý
FS = ³ÌÐò¼¯(CLR)±êÁ¿º¯Êý
FT = ³ÌÐò¼¯(CLR)±íÖµº¯Êý
R = ¹æÔò£¨¾Éʽ£¬¶ÀÁ¢£©
RF = ¸´ÖÆÉ¸Ñ¡´æ´¢¹ý³Ì
L = ÈÕÖ¾
FN = ±êÁ¿º¯Êý
IF = SQLÄÚÁª±íÖµº¯Êý
IT = ÄÚ²¿±í
S = ϵͳ±í
SN = ͬÒå´Ê
SQ = ·þÎñ¶ÓÁÐ
TA = ³ÌÐò¼¯(CLR) DML´¥·¢Æ÷
TR = SQL DML´¥·¢Æ÷
TF = SQL±íÖµº¯Êý
U = ±í£¨Óû§¶¨ÒåÀàÐÍ£©
UQ = UNIQUE Ô¼Êø£¨ÀàÐÍÊÇ K£©
V = ÊÓͼ
X = À©Õ¹´æ´¢¹ý³Ì
ÔÚÅöµ½´¥·¢Æ÷µÄÇéÐÎÏ£¬ÓÃÀ´Ê¶±ð´¥·¢Æ÷ÀàÐÍµÄÆäËûÈý¸öÁÐÊÇ£ºdeltrig¡¢instrigºÍuptrig¡£
Äã¿ÉÒÔÓÃÏÂÃæµÄÃüÁîÁгö¸ÐÐËȤµÄËùÓжÔÏó£º
SELECT * from sysobjects WHERE xtype = <type of interest>
 
ÔÚÌØÊâÇé¿öÏ£¬Ò²¾ÍÊÇÔÚ¸¸±í¸ñÓµÓд¥·¢Æ÷µÄÇé¿öÏ£¬Äã¿ÉÄÜÏëÒªÓÃÏÂÃæÕâÑùµÄ´úÂë²éÕÒÊý¾Ý¿â£º
SELECT
Sys2.[name] TableName,
Sys1.[name] TriggerName,
CASE
WHEN Sys1.deltrig > 0 THEN'Delete'
WHEN Sys1.instrig > 0 THEN'Insert'
WHEN Sys1.updtrig > 0 THEN'Update'
END'TriggerType'
from
sysobjects Sys1 JOIN sysobjects Sys2 ON Sys1.parent_obj = Sys2.[id]
WHERE Sys


Ïà¹ØÎĵµ£º

¾«ÃîSQLÓï¾äÕûÀí

Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:mssql7backupMyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack ......

SQL²Ù×÷È«¼¯

SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database db ......

Æ´½ÓSQLÔì³ÉµÄÒâÏë²»µ½µÄºó¹û

Ö´ÐÐÊý¾Ý²Ù×÷ʱ£¬ÓÉÓÚÆ´½ÓSQL´æÔÚÖÖÖÖ±×¶Ë£¬Ôç¾ÍÓ¦¸ÃÅׯúÁË£¬µ«ÔÚÏÖʵ¿ª·¢Ê±£¬ÓÖÓÉÓÚÖÖÖÖÔ­Òò£¬¹«Ë¾Ò»Ö±²ÉÓÃÕâÖÖ·½Ê½£¨UI²ãºÍÂß¼­²ã¶¼ÓÐÑϸñµÄ¹ýÂË£¬µ¹Ò²Ã»³öÏÖ¹ýʲôÎÊÌ⣩£¬µ«×òÌ쿪·¢Ê±È´³öÏÖÁËÒâÏë²»µ½µÄÎÊÌ⣬һ¸ö¼òµ¥µÄÓï¾ä»áÔì³ÉÑÏÖØºó¹û¡£¼òµ¥µÄÓï¾äʾÀýÈçÏ£º
    /// <summary>
&nb ......

SQLº¯Êý¿â

1.×Ö·û´®º¯Êý £º
datalength(Char_expr) ·µ»Ø×Ö·û´®°üº¬×Ö·ûÊý,µ«²»°üº¬ºóÃæµÄ¿Õ¸ñ
length(expression,variable)Ö¸¶¨×Ö·û´®»ò±äÁ¿Ãû³ÆµÄ³¤¶È¡£
substring(expression,start,length) ²»¶à˵ÁË,È¡×Ó´®
right(char_expr,int_expr) ·µ»Ø×Ö·û´®ÓÒ±ßint_expr¸ö×Ö·û
concat(str1,str2,...)·µ»ØÀ´×ÔÓÚ²ÎÊýÁ¬½áµÄ×Ö·û´®¡£dat ......

ʲôÊÇSQL×¢Èë

¿ÉÄÜ´ó¼Ò»¹²»ÊǶÔSQL×¢ÈëÕâ¸ö¸ÅÄî²»ÊǺÜÇå³þ£¬¼òµ¥µØËµ,SQL×¢Èë¾ÍÊǹ¥»÷Õßͨ¹ýÕý³£µÄWEBÒ³Ãæ,°Ñ×Ô¼ºSQL´úÂë´«Èëµ½Ó¦ÓóÌÐòÖÐ,´Ó¶øÍ¨¹ýÖ´ÐзdzÌÐòÔ±Ô¤ÆÚµÄSQL´úÂë,´ïµ½ÇÔÈ¡Êý¾Ý»òÆÆ»µµÄÄ¿µÄ¡£
¡¡¡¡µ±Ó¦ÓóÌÐòʹÓÃÊäÈëÄÚÈÝÀ´¹¹Ô춯̬SQLÓï¾äÒÔ·ÃÎÊÊý¾Ý¿âʱ£¬»á·¢ÉúSQL×¢Èë¹¥»÷¡£Èç¹û´úÂëʹÓô洢¹ý³Ì£¬¶øÕâЩ´æ´¢¹ý³Ì×÷Ϊ°üº ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ