MSSQL'08 有这样的定义功能吗 问问 各位, SQL Server 2008 能不能支持 在定义表结构时,可以定义 一个字段的 “说明”吗?找了很多资料都没有结果,但oracle是可以的啊,总想不通为什么 mssql怎么了?先谢谢大家。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 CREATE TABLE [dbo].[message]( [id] [int] IDENTITY(1,1) NOT NULL, [s_class] [nvarchar](12) NULL, [s_time] [datetime] NULL CONSTRAINT [DF_message_s_time] DEFAULT (getdate()), [s_msg] [nvarchar](max) NULL, [s_chk] [bit] NULL, CONSTRAINT [PK_message] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'这儿就是说明' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'message', @level2type=N'COLUMN',@level2name=N's_time' CREATE TABLE [dbo].[A]( [id] [int] NULL, [Name] [varchar](10) COLLATE Chinese_PRC_CI_AS NULL, [age] [int] NULL) ON [PRIMARY]GOSET ANSI_PADDING OFFGOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'A', @level2type=N'COLUMN', @level2name=N'id'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'A', @level2type=N'COLUMN', @level2name=N'Name'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年龄' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'A', @level2type=N'COLUMN', @level2name=N'age' 马上结题, 还有一问,那在 低版本 sql server 2000中有类似定义“说明”的创建语句么? 同一个表如何复制某字段到另一行记录 为什么别名不能在group by中用呢? SQL语句碰到难点了~~~~~ 怎样用sql语句得到sql server2000的master安装目录? sql server agent(服务无法启动) 新 Left Outer Join中的问题? 如何查询AdventureWorks示例数据库? 为什么老会提示错误引用了无效的表 进库表和库存表的一个问题。 MSSQL JOB 批量备份 这两个表如何联接 sql server 2005 自动备份
[id] [int] IDENTITY(1,1) NOT NULL,
[s_class] [nvarchar](12) NULL,
[s_time] [datetime] NULL CONSTRAINT [DF_message_s_time] DEFAULT (getdate()),
[s_msg] [nvarchar](max) NULL,
[s_chk] [bit] NULL,
CONSTRAINT [PK_message] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'这儿就是说明' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'message', @level2type=N'COLUMN',@level2name=N's_time'
CREATE TABLE [dbo].[A](
[id] [int] NULL,
[Name] [varchar](10) COLLATE Chinese_PRC_CI_AS NULL,
[age] [int] NULL
) ON [PRIMARY]GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'A', @level2type=N'COLUMN', @level2name=N'id'GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'A', @level2type=N'COLUMN', @level2name=N'Name'GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年龄' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'A', @level2type=N'COLUMN', @level2name=N'age'
马上结题,
还有一问,那在 低版本 sql server 2000中有类似定义“说明”的创建语句么?