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

sys.columns £¨SQL Server 2005 £©

Ϊ°üº¬ÁеĶÔÏó£¨ÈçÊÓͼ»ò±í£©µÄÿÁзµ»ØÒ»ÐС£ÏÂÃæÊÇ°üº¬ÁеĶÔÏóÀàÐ͵ÄÁÐ±í¡£
±íÖµ³ÌÐò¼¯º¯Êý (FT)
ÄÚÁª±íÖµ SQL º¯Êý (IF)
ÄÚ²¿±í (IT)
ϵͳ±í (S)
±íÖµ SQL º¯Êý (TF)
Óû§±í (U)
ÊÓͼ (V)
ÁÐÃû Êý¾ÝÀàÐÍ ËµÃ÷
object_id
int
´ËÁÐËùÊô¶ÔÏóµÄ ID¡£
name
sysname
ÁÐÃû¡£ÔÚ¶ÔÏóÖÐÊÇΨһµÄ¡£
column_id
int
ÁÐµÄ ID¡£ÔÚ¶ÔÏóÖÐÊÇΨһµÄ¡£
×¢Ò⣺
ÁÐ ID ²»ÄÜ°´Ë³ÐòÅÅÁС£
system_type_id
tinyint
ÁеÄϵͳÀàÐ굀 ID¡£
user_type_id
int
ÁеÄÀàÐ굀 ID£¬ÓÉÓû§¶¨Òå¡£
max_length
smallint
ÁеÄ×î´ó³¤¶È£¨×Ö½Ú£©¡£
-1 = ÁÐÊý¾ÝÀàÐÍΪ varchar(max)¡¢nvarchar(max)¡¢varbinary(max) »ò xml¡£
¶ÔÓÚ text ÁУ¬max_length ֵΪ 16 »òÊÇÓÉ sp_tableoption 'text in row' ÉèÖõÄÖµ¡£
precision
tinyint
Èç¹ûÁаüº¬µÄÊÇÊýÖµ£¬ÔòΪ¸ÃÁеľ«¶È£»·ñÔòΪ 0¡£
scale
tinyint
Èç¹û»ùÓÚÊýÖµ£¬ÔòΪÁеÄСÊýλÊý£»·ñÔòΪ 0¡£
collation_name
sysname
Èç¹ûÁаüº¬µÄÊÇ×Ö·û£¬ÔòΪ¸ÃÁÐÅÅÐò¹æÔòµÄÃû³Æ£»·ñÔòΪ NULL¡£
is_nullable
bit
1 = ÁпÉΪ¿Õ¡£
is_ansi_padded
bit
1 = Èç¹ûÁÐΪ×Ö·û¡¢¶þ½øÖÆ»ò±äÁ¿ÀàÐÍ£¬Ôò¸ÃÁÐʹÓà ANSI_PADDING ON ÐÐΪ¡£
0 = Áв»ÊÇ×Ö·û¡¢¶þ½øÖÆ»ò±äÁ¿¡£
is_rowguidcol
bit
1 = ÁÐΪÉùÃ÷µÄ ROWGUIDCOL¡£
is_identity
bit
1 = ÁоßÓбêʶֵ¡£
is_computed
bit
1 = ÁÐΪ¼ÆËãÁС£
is_filestream
bit
±£Áô¹©ÒÔºóʹÓá£
is_replicated
bit
1 = ÁÐÒѸ´ÖÆ¡£
is_non_sql_subscribed
bit
1 = ÁоßÓÐ·Ç SQL Server ¶©ÔÄ·þÎñÆ÷¡£
is_merge_published
bit
1 = ÁÐÒѺϲ¢·¢²¼¡£
is_dts_replicated
bit
1 = ʹÓà SQL Server 2005 Integration Services (SSIS) ¸´ÖÆÁС£
is_xml_document
bit
1 = ÄÚÈÝΪÍêÕûµÄ XML Îĵµ¡£
0 = ÄÚÈÝÊÇÎĵµÆ¬¶Î»òÁÐÊý¾ÝÀàÐͲ»ÊÇ xml¡£
xml_collection_id
int
Èç¹ûÁÐÊÇ xml ÇÒÒѼüÈë XML£¬ÔòΪ·ÇÁã¡£¸ÃÖµ½«Îª°üº¬ÁеÄÑéÖ¤ XML ¼Ü¹¹ÃüÃû¿Õ¼äµÄ¼¯ºÏµÄ ID¡£
0 = ûÓÐ XML ¼Ü¹¹¼¯ºÏ¡£
default_object_id
int
ĬÈ϶ÔÏóµÄ ID£¬ÎÞÂÛËüÊǶÀÁ¢¶ÔÏó sys.sp_bindefault »¹ÊÇÄÚÁªÁм¶ DEFAULT Ô¼Êø¡£ÄÚÁªÁм¶Ä¬È϶ÔÏóµÄ parent_object_id ÁÐÊÇ¶Ô¸Ã±í±¾ÉíµÄ·´ÒýÓá£
0 = ÎÞĬÈÏÖµ¡£
rule_object_id
int
ʹÓà sys.sp_bindrule °ó¶¨µ½ÁеĶÀÁ¢¹æÔòµÄ ID¡£
0 = ÎÞ¶ÀÁ¢¹æÔò¡£ÓйØÁм¶ CHECK Ô¼ÊøµÄÐÅÏ¢£¬Çë²ÎÔÄ sys.check_constraints


Ïà¹ØÎĵµ£º

SQLÖаѲéѯ³öÀ´µÄ½á¹ûÓöººÅÁ¬½ÓÆðÀ´

SELECT A,B=stuff((select ' ' + '×Ö¶ÎC£º' + C + ',×Ö¶ÎD£º'  + D) + ';'  from tbl WHERE (key= 'Ìõ¼þ') for xml path('')) , 1 , 1 ,'')
from tbl
WHERE (key= 'Ìõ¼þ')
group by key
ÀýÈ磺һ¸ö±íÖÐkeyΪAAµÄ¼Ç¼ÓÐ2Ìõ£¬µÚÒ»ÌõÖÐ×Ö¶ÎCµÄֵΪCC£¬×Ö¶ÎDµÄֵΪDD£¬µÚ¶þÌõÖÐ×Ö¶ÎCµÄֵΪCCC£¬×Ö¶ÎDµÄֵΪ ......

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Óï¾ä

1. ²é¿´Êý¾Ý¿âµÄ°æ±¾       
   select @@version
  2. ²é¿´Êý¾Ý¿âËùÔÚ»úÆ÷²Ù×÷ϵͳ²ÎÊý       
  exec master..xp_msver
  3. ²é¿´Êý¾Ý¿âÆô¶¯µÄ²ÎÊý        
  ......

HibernateÓëSQLµÄÑ¡Ôñ

HibernateÊÇÒ»¿îÓÅÐãµÄORM¹¤¾ß¡£µ«ÊÇÔÚijЩÇé¿öÏÂÄÑÃâ»á¸øÎÒÃǵÄÏîÄ¿´øÀ´Ò»¶¨µÄ¸´ÔÓÐÔ¡£¾ÍËãʹÓÃspring×öÒ»¶¨µÄÊÂÎñ¼ò»¯£¬¸Ä±äµÄÒ²½ö½öÊDZàдµÄʱºò¸ü¼ÓµÄ¼òµ¥¶øÒÑ¡£ÌرðÊÇÔÚ´¦Àí²éѯµÄʱºò£¬hibernateºÍsql±È½ÏÆðÀ´£¬¾ÍËƺõûÓÐÄÇô´óµÄÓÅÊÆÁË¡£ËùÒÔÔںܶàµÄÏîÄ¿ÀïÃæÔÚʹÓÃhibernateºÍspringµÄͬʱ»¹»áʹÓÃibatisµÄsqlmap¡ ......

ʹִÐеÄsqlÓï¾ä±äΪlinuxºǫ́½ø³ÌÖ´ÐÐ

ǰЩÈÕ×Ó£¬ÔÚ²Ù×÷Êý¾Ý¿âʱ£¬ÐèÒªÖ´ÐвÙ×÷ʱ¼äºÜ¾ÃµÄsqlÓï¾ä¡£µ«Êǵ±Ê±¾ÖÓòÍøÍøÂçÇé¿ö²»ºÃ£¬¾­³£·¢ÉúµôÏßµÄÇé¿ö¡£
´ËʱÐèÒª°ÑÖ´ÐеÄÓï¾ä¼ÓÈëµ½oracle·þÎñÆ÷Éϵĺǫ́½ø³ÌÖУ¬È¥Ö´ÐС£²Ù×÷¹ý³ÌÈçÏ£º
1¡¢Ê×ÏÈ°ÑÐèÒªÖ´ÐеÄsqlÓï¾äд³É½Å±¾£¬´æ´¢µ½sql.sqlÖС£²¢·ÅÖõ½Êý¾Ý¿â·þÎñÆ÷ij·¾¶ÏÂ.
2¡¢Ö´ÐÐÈçÏÂlinuxÃüÁî¼´¿É£º
&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ