sqlserver用命令创建表代码并注释

Sure, 下面是 SQL Server 创建表并注释的命令：

CREATE TABLE [dbo].[Table_Name](
    [Column1] [Data_Type] NULL,
    [Column2] [Data_Type] NOT NULL,
    [Column3] [Data_Type] NOT NULL,
    CONSTRAINT [PK_Table_Name] PRIMARY KEY CLUSTERED 
    (
        [Column2] ASC,
        [Column3] ASC
    )
) ON [PRIMARY];
GO

EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'Description of Column1' , 
@level0type=N'SCHEMA',@level0name=N'dbo',
@level1type=N'TABLE',@level1name=N'Table_Name',
@level2type=N'COLUMN',@level2name=N'Column1';
GO

EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'Description of Column2' , 
@level0type=N'SCHEMA',@level0name=N'dbo',
@level1type=N'TABLE',@level1name=N'Table_Name',
@level2type=N'COLUMN',@level2name=N'Column2';
GO

EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'Description of Column3' , 
@level0type=N'SCHEMA',@level0name=N'dbo',
@level1type=N'TABLE',@level1name=N'Table_Name',
@level2type=N'COLUMN',@level2name=N'Column3';
GO

上面的代码创建了一个名为 Table_Name 的表，有三个列 Column1、Column2、Column3。Column1 列可以为 null，Column2、Column3 列不允许为空，作为主键。同时，使用 sp_addextendedproperty 存储过程为每一个列添加了注释。