测试所用的表:table24
结构及意义:
field1:主键序号
field2:日期
field3:当前日期是本年度的第几周(用来查询)
field4:星期几(如星期一)
field5:年份
建表SQL:
CREATE TABLE [dbo].[table24](
[field1] [int] IDENTITY(1,1) NOT NULL,
[field2] [datetime] NULL,
[field3] [int] NULL,
[field4] [varchar](10) COLLATE Chinese_PRC_CI_AS NULL,
[field5] [int] NULL,
CONSTRAINT [PK_table24] PRIMARY KEY CLUSTERED
(
[field1] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) 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'table24', @level2type=N'COLUMN', @level2name=N'field1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'日期' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',