Question

求自动生成字段说明sql语句脚本

已知有表sjzd（表名，字段名，字段说明），
把sjzd表中每个表的字段分别添加字段说明，要求编写sql语句自动生成脚本，要生成这种格式的
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cpc_qyb_qyrkxx', @level2type=N'COLUMN',@level2name=N'id'
GO

Answer 1

如建立了个表是 WoolenDeliveDetail，更新表的存储过程是UP_WoolenDeliveDetailCREATE PROCEDURE UP_WoolenDeliveDetail @INTUpdateID INT,--为-1 删除0 修改1新增 @INTDeDetailID INT, @INTDeID INT, @INTColorID INT, @NVD1 NVARCHAR(20), @NVD2 NVARCHAR(20), @NVD3 NVARCHAR(20), @NVD4 NVARCHAR(20), @NVD5 NVARCHAR(20), @NVD6 NVARCHAR(20), @NVD7 NVARCHAR(20), @NVD8 NVARCHAR(20), @NVD9 NVARCHAR(20), @NVD10 NVARCHAR(20) AS IF (@INTUpdateID=0) Begin UPDATE