官方自带的,我觉得麻烦,稍微‘封装’一下
create proc Proc_AddExplian @table varchar(200), @clolum varchar(200), @text varchar(200) as begin EXEC sp_addextendedproperty 'MS_Description', @text, 'USER', dbo, 'TABLE', @table, 'COLUMN', @clolum; end
exec Proc_AddExplian 'BBS_SiteStats' ,'WebVisitIP','独立ip访问量'