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

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Óï¾äÔÚÍⲿ¶Ô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ʵÏÖÍêÈ«ÅÅÁÐ×éºÏ

---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 ......

PL/SQL Developer ÖÐÎÄÂÒÂë½â¾ö

1¡£select * from v$nls_parameters 
²éѯnlsµÄ²ÎÊý£¬»ñµÃÊý¾Ý¿â·þÎñÆ÷¶ËµÄ×Ö·û±àÂë 
NLS_LANGUAGE 
NLS_CHARACTERSET 
2¡£Ð޸ı¾µØ»·¾³±äÁ¿£¬ÉèÖà
NLS_LANG = SIMPLIFIED CHINESE.ZHS16GBK //Õâ¸öÊÇÎÒÃǵÄÊý¾Ý¿â×Ö·û±àÂë 
NLS_LANG¸ñʽ£º 
NLS_LANG = language_territory.char ......

³£ÓÃSqlÓï¾ä

ʹÓà TRUNCATE TABLE ɾ³ýËùÓÐÐÐ
ÈôҪɾ³ý±íÖеÄËùÓÐÐУ¬Ôò TRUNCATE TABLE Óï¾äÊÇÒ»ÖÖ¿ìËÙ¡¢ÓÐЧµÄ·½·¨¡£TRUNCATE TABLE Óë²»º¬ WHERE ×Ó¾äµÄ DELETE Óï¾äÀàËÆ¡£µ«ÊÇ£¬TRUNCATE TABLE Ëٶȸü¿ì£¬²¢ÇÒʹÓøüÉÙµÄϵͳ×ÊÔ´ºÍÊÂÎñÈÕÖ¾×ÊÔ´¡£
Óë DELETE Óï¾äÏàͬ£¬Ê¹Óà TRUNCATE TABLE Çå¿ÕµÄ±íµÄ¶¨ÒåÓëÆäË÷ÒýºÍÆäËû¹ØÁª¶ÔÏóÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ