在工作中我们一般会遇到将横列转成纵列的需求,下面是横列转纵列的案例:1.建表CREATE TABLE [dbo].[AcrossChangeEndLong]( [Id] [INT] IDENTITY(1,1) NOT NULL, [Name] [NVARCHAR](50) N ...
在工作中我们一般会遇到将横列转成纵列的需求,下面是横列转纵列的案例:
1.建表
CREATE TABLE [dbo].[AcrossChangeEndLong]( [Id] [INT] IDENTITY(1,1) NOT NULL, [Name] [NVARCHAR](50) NOT NULL, [Subject] [NVARCHAR](50) NOT NULL, [Score] [INT] NOT NULL, CONSTRAINT [PK_AcrossChangeEndLong] 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]GOALTER TABLE [dbo].[AcrossChangeEndLong] ADD CONSTRAINT [DF_AcrossChangeEndLong_Score] DEFAULT ((0)) FOR [Score]GO
原标题:MSSQL横列转纵列
关键词:MSSQL
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。