Ϊ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
Ïà¹ØÎĵµ£º
ÕâÁ½ÌìÓиöÐèÇó£¬ÐèÒªÔÚÊý¾Ý¿âÖÐÅжÏ×Ö·û´®µÄ¸ñʽ£¬ÓÚÊÇ´ÓÍøÉÏËѼ¯ÁËһЩ×ÊÁÏ£¬ÕûÀíÁËһϡ£
ÏÂÃæÕâ¸öÊÇÒ»¸ö×Ô¶¨Ò庯Êý£¬Óû§¿ÉÒÔµ÷ÓÃÕâ¸öº¯ÊýÅжÏÖ¸¶¨µÄ×Ö·û´®ÊÇ·ñ·ûºÏÕýÔò±í´ïʽµÄ¹æÔò.
CREATE FUNCTION dbo.find_regular_expression
(
@source varchar(5000), --ÐèҪƥÅäµÄÔ´× ......
1.SQLServerµÄ´´½¨½Å±¾ÈçÏ£º
USE [master]
GO
/****** Object: Database [test] Script Date: 10/29/2009 17:43:10 ******/
CREATE DATABASE [test] ON PRIMARY
( NAME = N'test', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\test.mdf' , S ......
תÔØ×Ô£ºhttp://sunfreesky.blog.163.com/blog/static/211116820097224822596/
SQLServer°²×°³ÌÐòÅäÖ÷þÎñÆ÷ʧ°Ü.²Î¿¼·þÎñÆ÷´íÎóÈÕÖ¾ºÍc:\windows\sqlstp.logÁ˽â¸ü¶àÐÅÏ¢”´íÎó
2007Äê07ÔÂ15ÈÕ ÐÇÆÚÈÕ 16:25
SQL 2000 °²×°³ÌÐòÅäÖ÷þÎñÆ÷ʧ°Ü½â¾ö·½·¨£º
ÈÕÖ¾ÎļþÒýÓÃÄÚÈÝ£º
13:09:40 Process Ex ......
ÓÃwindowsÕ˺Ż¹ÊÇ¿ÉÒԵǼµÄ¡£
²éÕÒÎÊÌâµÄ¹ý³Ì£º
µÚÒ»²½£º Æô¶¯ËùÓÐÓëSQLÓйصķþÎñ£¬ÎÊÌâÒÀ¾É£»
µÚ¶þ²½£º ²é¿´windows·À»ðǽ£¬±»Ä¬ÈÏÆô¶¯ÁË£¬²»Æô¶¯Ñ¡ÔñÏî±»Disabled¡£Á½¸öÌáʾ“ÓÉÓÚ°²È«¿¼ÂÇ,ijЩÉèÖÃÓÉ×é²ßÂÔ¿ØÖÆ”“Windows·À»ðǽÕýÔÚʹÓÃÄúµÄÓòÉèÖÔ£¬ÏÈÓÃgpedit.msc´ò×é²ßÂÔ±à¼Æ÷£¬» ......