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

Ϊ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+JavaÁ¬½ÓSQLServerÊý¾Ý¿â

 Ê×ÏÈ£¬×öÒ»µã˵Ã÷¡£FlexÊDz»ÄÜÖ±½ÓÁ¬½ÓÊý¾Ý¿âµÄ£¬ÕâÒ»µã´ó¼ÒÐèÒªÖªµÀ£¬ËüÖ»Äܼä½ÓµØÁ¬½ÓÊý¾Ý¿â¡£FlexÖÐÌṩÁËÈýÖÖ·½Ê½£ºHttpService£¬WebService ºÍRemoteObject¡£ÆäÖÐHttpService¿ÉÒÔÖ±½Ó»ñÈ¡XMLÖеÄÊý¾Ý£¬»¹¿ÉÒÔͨ¹ýJSP,ASPÒÔ¼°PHP¶ÁÈ¡Êý¾Ý¿âÖеÄÊý¾Ý£¬Õâ¸ö±È½Ï¼òµ¥£¬¶øÇÒÍøÉÏÒ²ÓкܶàÀý×Ó£¬ÎҾͲ»¶à˵ÁË¡£WebServi ......

SQLServer½«ÈÕÆÚת»»³É×Ö·û´®¸ñʽ

 SELECT   convert(char,ÈÕÆÚ×Ö¶Î,120)   as   date2   from   table
mssqlĬÈÏÒÔϵͳʱ¼ä¸ñʽÊä³ö£¬Äã¿ÉÒÔµ÷ÕûϵͳµÄʱ¼ä¸ñʽÀ´½â¾ö
µ±È»ÊÇÔÚ³ÌÐòÀï½â¾ö±È½ÏÁé»î£¬convert(char,date,N)Êä³öµÄ¸÷ÖÖÑùʽ
N   ÈÕÆÚÑùʽ  
0   04& ......

SQLServerËø»úÖÆÑо¿

 
Ïà¹ØÎÄÕÂ:  
mysqlÊý¾Ý¿âËø
ORACLEÀXÖÖËøģʽ
ÍƼöȦ×Ó: Pipboy
¸ü¶àÏà¹ØÍƼö
new Draggable("related_topics");

¶ÔËø»úÖƵÄÑо¿Òª¾ß±¸Á½¸öÌõ¼þ£º
1£®Êý¾ÝÁ¿´ó
2£®¶à¸öÓû§Í¬Ê±²¢·¢
Èç¹ûȱÉÙÕâÁ½¸öÌõ¼þ£¬Êý¾Ý¿â²»ÈÝÒײúÉúËÀËøÎÊÌâ¡£Ñо¿ÆðÀ´¿ÉÄÜ»áʱ¶¹ ......

SQLServer ÅúÁ¿²åÈëÊý¾ÝµÄÁ½ÖÖ·½·¨

SQLServer ÅúÁ¿²åÈëÊý¾ÝµÄÁ½ÖÖ·½·¨
2009-07-27 19:31
ÔÚSQL Server ÖвåÈëÒ»ÌõÊý¾ÝʹÓÃInsertÓï¾ä£¬µ«ÊÇÈç¹ûÏëÒªÅúÁ¿²åÈëÒ»¶ÑÊý¾ÝµÄ»°£¬Ñ­»·Ê¹ÓÃInsert²»½öЧÂʵͣ¬¶øÇһᵼÖÂSQLһϵͳÐÔÄÜÎÊÌâ¡£ÏÂÃæ½éÉÜSQL ServerÖ§³ÖµÄÁ½ÖÖÅúÁ¿Êý¾Ý²åÈë·½·¨£ºBulkºÍ±íÖµ²ÎÊý(Table-Valued Parameters)¡£
    &nb ......

Sqlserver ÖÐunionºÍorder by ×Ó¾äµÄÎÊÌâ

UnionĬÈÏÊDz»ÄÜÓÐorder by×Ó¾ä
Èç¹ûÐèÒªÅÅÐò£¬ÔòÖ»ÄÜÈçÏÂʵÏÖ 
select * from (select top 100 PERCENT  * from ±íÃû order by ×Ö¶ÎÃû) a
               union all
 select * from (select top 100 PERCENT  * from ±íÃû ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ