sqlµÄ±íĿ¼ÊÓͼ
sysaltfiles ÔÚmasterÊý¾Ý¿âÖУ¬°üº¬ÓëÊý¾Ý¿âÎļþÏà¶ÔÓ¦µÄÐÅÏ¢£¬°üº¬ËùÓÐÊý¾Ý¿âµÄÊý¾ÝÎļþÒÔ¼°ÈÕÖ¾Îļþ
ÁÐÃûÊý¾ÝÀàÐÍÃèÊö
fileid
smallint
ÿ¸öÊý¾Ý¿âµÄΨһÎļþ±êʶºÅ¡£1´ú±íÊý¾ÝÎļþ£¬2´ú±íÈÕÖ¾Îļþ
groupid
smallint
Îļþ×é±êʶºÅ¡£
size
int
Îļþ´óС£¨ÒÔ 8 KB ҳΪµ¥Î»£©¡£Ò³µÄÊýÄ¿
maxsize
int
×î´óÎļþ´óС£¨ÒÔ 8 KB ҳΪµ¥Î»£©¡£0 Öµ±íʾ²»Ôö³¤£¬–1 Öµ±íʾÎļþÓ¦Ò»Ö±Ôö³¤µ½´ÅÅÌÒÑÂú¡£
growth
int
Êý¾Ý¿âµÄÔö³¤´óС¡£0 Öµ±íʾ²»Ôö³¤¡£¸ù¾Ý״̬µÄÖµ£¬¿ÉÒÔÊÇÒ³Êý»òÎļþ´óСµÄ°Ù·Ö±È¡£Èç¹û status Ϊ 0x100000£¬Ôò growth ÊÇÎļþ´óСµÄ°Ù·Ö±È£»·ñÔòÊÇÒ³Êý¡£
status
int
½öÏÞÄÚ²¿Ê¹Óá£
perf
int
±£Áô¡£
dbid
smallint
Êý¾Ý¿âID
name
nchar(128)
ÎļþµÄÂß¼Ãû³Æ¡£
filename
nchar(260)
ÎïÀíÉ豸µÄÃû³Æ£¬°üÀ¨ÎļþµÄÍêÕû·¾¶¡£
sys.databases sql2005µÄÊÓͼ
sysdatabase ÊÇΪÁ˼æÈÝÒÔǰµÄ°æ±¾µÄ
ÕâÁ½¸öÊǰüº¬²»Í¬µÄÐÅÏ¢ÊÓͼ£¬sys.databases °üº¬µÄ¸ü¶àµÄÊÇһЩ set ÉèÖÃÐÅÏ¢ £¬sysdatabase°üº¬µÄÖ÷ÒªÊÇÊý¾ÝÎļþ·¾¶ÐÅÏ¢¡£
syscolumns ±íµÄÁÐÐÅÏ¢
syscomments
syscolumns
syscharsets
ÿ¸ö×Ö·û¼¯ÔÚ±íÖи÷Õ¼Ò»ÐУ¬±íÖл¹°üº¬¶¨Ò幩 Microsoft? SQL Server? ʹÓõÄÅÅÐò´ÎÐò¡£ÅÅÐò´ÎÐòÖеÄÒ»¸öÔÚ sysconfigures Öбê¼ÇΪĬÈÏÅÅÐò´ÎÐò£¬¸Ã´ÎÐòÊÇʵ¼ÊʹÓõÄΨһ´ÎÐò¡£
sysconfigures
ÿ¸öµ±Ç°ÅäÖÃÑ¡Ïî¸÷Õ¼Ò»Ïî¡£ÁíÍ⣬¸Ã±í»¹°üº¬ËĸöÃèÊöÅäÖýṹµÄÏî¡£ syscurconfigs ÔÚÓÉÓû§²éѯʱ¶¯Ì¬Éú³É¡£Óйظü¶àÐÅÏ¢£¬Çë²Î¼û
ÁÐÃûÊý¾ÝÀàÐÍÃèÊö
value
int
±äÁ¿µÄÓû§¿ÉÐÞ¸ÄÖµ£¨½öÔÚÒÑÖ´ÐÐ RECONFIGURE ºóÓÉ SQL Server ʹÓã©¡£
config
smallint
ÅäÖñäÁ¿ºÅ¡£
comment
nvarchar(255)
¶ÔÅäÖÃÑ¡ÏîµÄ½âÊÍ¡£
status
smallint
±íʾѡÏî״̬µÄλͼ¡£¿ÉÄܵÄÖµ°üÀ¨£º
0 = ¾²Ì¬£¨¸ÃÉèÖÃÔÚ·þÎñÆ÷ÖØÐÂÆô¶¯Ê±ÉúЧ£©¡£
1 = ¶¯Ì¬£¨¸Ã±äÁ¿ÔÚ RECONFIGURE Óï¾äÖ´ÐÐʱÉúЧ£©¡£
2 = ¸ß¼¶£¨½öµ±ÉèÖÃÁËÏÔʾ¸ß¼¶Ñ¡Ïîʱ²ÅÏÔʾ¸Ã±äÁ¿£©¡£
3 = ¶¯Ì¬ºÍ¸ß¼¶¡£
sysfiles
sysindexes
Êý¾Ý¿âÖеÄÿ¸öË÷ÒýºÍ±íÔÚ±íÖи÷Õ¼Ò»ÐС£¸Ã±í´æ´¢ÔÚÿ¸öÊý¾Ý¿âÖС£°üº¬Í³¼ÆÐÅÏ¢
ÁÐÃûÊý¾ÝÀàÐÍÃèÊö
id
int
±í ID£¨Èç¹û indid = 0 »ò 255£©¡£·ñÔòΪË÷ÒýËùÊô±íµÄ ID¡£
status
int
ÄÚ²¿ÏµÍ³×´Ì¬ÐÅÏ¢¡£
first
binary(6)
Ö¸ÏòµÚÒ»Ò³»ò¸ùÒ³µÄÖ¸Õë¡£
i
Ïà¹ØÎĵµ£º
SQL£¨½á¹¹»¯²éѯÓïÑÔ£©×¢È룬¼òµ¥À´Ëµ¾ÍÊÇÀûÓÃSQLÓï¾äÔÚÍⲿ¶ÔSQLÊý¾Ý¿â½øÐвéѯ£¬¸üеȶ¯×÷¡£Ê×ÏÈ£¬Êý¾Ý¿â×÷Ϊһ¸öÍøÕ¾×îÖØÒªµÄ×é¼þÖ®Ò»£¨Èç¹ûÕâ¸öÍøÕ¾ÓÐÊý¾Ý¿âµÄ»°£©£¬ÀïÃæÊÇ´¢´æ×Ÿ÷ÖÖ¸÷ÑùµÄÄÚÈÝ£¬°üÀ¨¹ÜÀíÔ±µÄÕ˺ÅÃÜÂë ......
н¨±í£º
create table [±íÃû]
(
[×Ô¶¯±àºÅ×Ö¶Î] int IDENTITY (1,1) PRIMARY KEY ,
[×Ö¶Î1] nVarChar(50) default 'ĬÈÏÖµ' null ,
[×Ö¶Î2] ntext null ,
[×Ö¶Î3] datetime,
[×Ö¶Î4] money null ,
[×Ö¶Î5] int default 0,
[×Ö¶Î6] Decimal (12,4) default 0,
[×Ö¶Î7] image null ,
)
ɾ³ý±í£º
Drop table [±í ......
---SQLʵÏÖÍêÈ«ÅÅÁÐ×éºÏ
create function F_strSpit(@s varchar(200)) returns table
as
return(
select value=substring(@s,i,num)+substring(@s,num-1+j,1)
from (select num=number from spt_values where type='p' and number<len(@s) and number>0)TA,
(select i=number+1 from spt_values where type='p ......
1¡£select * from v$nls_parameters
²éѯnlsµÄ²ÎÊý£¬»ñµÃÊý¾Ý¿â·þÎñÆ÷¶ËµÄ×Ö·û±àÂë
NLS_LANGUAGE
NLS_CHARACTERSET
2¡£Ð޸ı¾µØ»·¾³±äÁ¿£¬ÉèÖÃ
NLS_LANG = SIMPLIFIED CHINESE.ZHS16GBK //Õâ¸öÊÇÎÒÃǵÄÊý¾Ý¿â×Ö·û±àÂë
NLS_LANG¸ñʽ£º
NLS_LANG = language_territory.char ......
ʹÓà TRUNCATE TABLE ɾ³ýËùÓÐÐÐ
ÈôҪɾ³ý±íÖеÄËùÓÐÐУ¬Ôò TRUNCATE TABLE Óï¾äÊÇÒ»ÖÖ¿ìËÙ¡¢ÓÐЧµÄ·½·¨¡£TRUNCATE TABLE Óë²»º¬ WHERE ×Ó¾äµÄ DELETE Óï¾äÀàËÆ¡£µ«ÊÇ£¬TRUNCATE TABLE Ëٶȸü¿ì£¬²¢ÇÒʹÓøüÉÙµÄϵͳ×ÊÔ´ºÍÊÂÎñÈÕÖ¾×ÊÔ´¡£
Óë DELETE Óï¾äÏàͬ£¬Ê¹Óà TRUNCATE TABLE Çå¿ÕµÄ±íµÄ¶¨ÒåÓëÆäË÷ÒýºÍÆäËû¹ØÁª¶ÔÏóÒ ......