文章分类 -  SQL

SQL
摘要:求解:动态行转列CREATE TABLE [dbo].test3([id] [bigint] IDENTITY(1,1) NOT NULL,[P_ID] [bigint] NOT NULL,[day] [varchar](12) NULL,[PTime] [datetime] NOT NULL,[TimeType] [int] NOT NULL,CONSTRAINT test3 PRIMARY KEY CLUSTERED ([id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, AL 阅读全文
posted @ 2012-04-11 17:04 yiyan21 阅读(139) 评论(0) 推荐(0)