ΪSQLServer±íÖеÄ×Ö¶ÎÌí¼Ó˵Ã÷
ÔÚSQLÓï¾äÖÐͨ¹ýϵͳ´æ´¢¹ýsp_addextendedproperty¿ÉΪ±í×Ö¶ÎÌí¼ÓÉ϶¯Ì¬µÄ˵Ã÷£¨±¸×¢£©ÏÂÃæÊÇSQL SERVER°ïÖúÎĵµÖжÔsp_addextendedproperty´æ´¢¹ý³ÌµÄÃèÊö
Óï·¨
sp_addextendedproperty
[ @name = ] { 'property_name' }
[ , [ @value = ] { 'value' }
[ , [ @level0type = ] { 'level0_object_type' }
, [ @level0name = ] { 'level0_object_name' }
[ , [ @level1type = ] { 'level1_object_type' }
, [ @level1name = ] { 'level1_object_name' }
[ , [ @level2type = ] { 'level2_object_type' }
, [ @level2name = ] { 'level2_object_name' }
]
]
]
]
²ÎÊý
[ @name = ] { 'property_name' }
ÒªÌí¼ÓµÄÊôÐÔÃû³Æ¡£property_name µÄÊý¾ÝÀàÐÍΪ sysname£¬Ëü²»ÄÜÊÇ NULL¡£Ãû³Æ¿ÉÄÜ»¹°üÀ¨¿Õ°×»ò·Ç×ÖĸÊý×Ö×Ö·û´®ºÍ¶þ½øÖÆÖµ¡£
[ @value = ] { 'value' }
½«ÒªÓëÊôÐÔÏà¹ØÁªµÄÖµ¡£value µÄÊý¾ÝÀàÐÍΪ sql_variant£¬´øÓÐĬÈÏÉèÖà NULL¡£value µÄ´óС²»Äܳ¬¹ý 7,500 ×Ö½Ú£»·ñÔò SQL Server »á²úÉú´íÎó¡£
[ @level0type = ] { 'level0_object_type' }
Óû§»òÓû§¶¨ÒåÀàÐÍ¡£level0_object_type µÄÊý¾ÝÀàÐÍΪ varchar(128)£¬ÆäĬÈÏֵΪ NULL¡£ÓÐЧµÄÊäÈëÊÇ USER¡¢TYPE ºÍ NULL¡£
[ @level0name = ] { 'level0_object_name' }
Ö¸¶¨µÄ 0 ¼¶¶ÔÏóÀàÐ͵ÄÃû³Æ¡£level0_object_name µÄÊý¾ÝÀàÐÍΪ sysname£¬ÆäĬÈÏֵΪ NULL¡£
[ @level1type = ] { 'level1_object_type' }
1 ¼¶¶ÔÏóµÄÀàÐÍ¡£level1_object_type µÄÊý¾ÝÀàÐÍΪ varcha
Ïà¹ØÎĵµ£º
Ê×ÏÈ£¬×öÒ»µã˵Ã÷¡£FlexÊDz»ÄÜÖ±½ÓÁ¬½ÓÊý¾Ý¿âµÄ£¬ÕâÒ»µã´ó¼ÒÐèÒªÖªµÀ£¬ËüÖ»Äܼä½ÓµØÁ¬½ÓÊý¾Ý¿â¡£FlexÖÐÌṩÁËÈýÖÖ·½Ê½£ºHttpService£¬WebService ºÍRemoteObject¡£ÆäÖÐHttpService¿ÉÒÔÖ±½Ó»ñÈ¡XMLÖеÄÊý¾Ý£¬»¹¿ÉÒÔͨ¹ýJSP,ASPÒÔ¼°PHP¶ÁÈ¡Êý¾Ý¿âÖеÄÊý¾Ý£¬Õâ¸ö±È½Ï¼òµ¥£¬¶øÇÒÍøÉÏÒ²ÓкܶàÀý×Ó£¬ÎҾͲ»¶à˵ÁË¡£WebServi ......
SELECT convert(char,ÈÕÆÚ×Ö¶Î,120) as date2 from table
mssqlĬÈÏÒÔϵͳʱ¼ä¸ñʽÊä³ö£¬Äã¿ÉÒÔµ÷ÕûϵͳµÄʱ¼ä¸ñʽÀ´½â¾ö
µ±È»ÊÇÔÚ³ÌÐòÀï½â¾ö±È½ÏÁé»î£¬convert(char,date,N)Êä³öµÄ¸÷ÖÖÑùʽ
N ÈÕÆÚÑùʽ
0 04& ......
Ïà¹ØÎÄÕÂ:
mysqlÊý¾Ý¿âËø
ORACLEÀXÖÖËøģʽ
ÍƼöȦ×Ó: Pipboy
¸ü¶àÏà¹ØÍƼö
new Draggable("related_topics");
¶ÔËø»úÖƵÄÑо¿Òª¾ß±¸Á½¸öÌõ¼þ£º
1£®Êý¾ÝÁ¿´ó
2£®¶à¸öÓû§Í¬Ê±²¢·¢
Èç¹ûȱÉÙÕâÁ½¸öÌõ¼þ£¬Êý¾Ý¿â²»ÈÝÒײúÉúËÀËøÎÊÌâ¡£Ñо¿ÆðÀ´¿ÉÄÜ»áʱ¶¹ ......
SQLServer ÅúÁ¿²åÈëÊý¾ÝµÄÁ½ÖÖ·½·¨
2009-07-27 19:31
ÔÚSQL Server ÖвåÈëÒ»ÌõÊý¾ÝʹÓÃInsertÓï¾ä£¬µ«ÊÇÈç¹ûÏëÒªÅúÁ¿²åÈëÒ»¶ÑÊý¾ÝµÄ»°£¬Ñ»·Ê¹ÓÃInsert²»½öЧÂʵͣ¬¶øÇһᵼÖÂSQLһϵͳÐÔÄÜÎÊÌâ¡£ÏÂÃæ½éÉÜSQL ServerÖ§³ÖµÄÁ½ÖÖÅúÁ¿Êý¾Ý²åÈë·½·¨£ºBulkºÍ±íÖµ²ÎÊý(Table-Valued Parameters)¡£
&nb ......
UnionĬÈÏÊDz»ÄÜÓÐorder by×Ó¾ä
Èç¹ûÐèÒªÅÅÐò£¬ÔòÖ»ÄÜÈçÏÂʵÏÖ
select * from (select top 100 PERCENT * from ±íÃû order by ×Ö¶ÎÃû) a
union all
select * from (select top 100 PERCENT * from ±íÃû ......