ＡｉＴパートナー公開情報

--?J?????̊g???v???p?e?B?[??lj?????R?}???h

Declare @ColName as nvarchar(50)

Declare @TableName as nvarchar(50)

Declare @ColNameDesc01 as nvarchar(100)

Declare @ColNameDesc02 as nvarchar(100)

Set @TableName='TableName'

Set @ColName='ColmunName'

Set @ColNameDesc01='?f?[?^?\?[?X'

Set @ColNameDesc02='?J??????'

-- ?V?K?ō쐬????ꍇ

EXEC sys.sp_addextendedproperty @name=N'DataSours', @value=@ColNameDesc01 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=@TableName, @level2type=N'COLUMN',@level2name=@ColName

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=@ColNameDesc02 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=@TableName, @level2type=N'COLUMN',@level2name=@ColName

-- ?????X?V????ꍇ

EXEC sys.sp_updateextendedproperty @name=N'DataSours', @value=@ColNameDesc01 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=@TableName, @level2type=N'COLUMN',@level2name=@ColName

EXEC sys.sp_updateextendedproperty @name=N'MS_Description', @value=@ColNameDesc02 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=@TableName, @level2type=N'COLUMN',@level2name=@ColName