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

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

Declare @TableName as nvarchar(50)

Declare @TableNameDesc01 as nvarchar(100)

Declare @TableNameDesc02 as nvarchar(100)

Set @TableName='TableName'

Set @TableNameDesc01='?e?[?u????'

Set @TableNameDesc02='?e?[?u???̐???'

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=@TableNameDesc01 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=@TableName

EXEC sys.sp_addextendedproperty @name=N'Description', @value=@TableNameDesc02 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=@TableName

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

exec sys.sp_updateextendedproperty @name=N'MS_Description', @value=@TableNameDesc01 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=@TableName

exec sys.sp_updateextendedproperty @name=N'Description', @value=@TableNameDesc02 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=@TableName