如何将列转为行????详见内

lyq 2004-04-01 10:22:49
表结构：
sgybh,ssjr,ssjrq,sbmmc,sfgbh,spzbh,spzmc,sbz,
scst1(参数),scs1(值),scst2,scs2......scst60,scs60

转换为：
sgybh,ssjr,ssjrq,sbmmc,sfgbh,spzbh,spzmc,sbz,参数，值


前提，表中只有一行数据。
...全文
58 10 打赏 收藏 转发到动态 举报
写回复
用AI写文章
10 条回复
切换为时间正序
请发表友善的回复…
发表回复
zjcxc 元老 2004-04-01
  • 打赏
  • 举报
 回复
--应该是这种意思了.

declare @s varchar(8000),@tbname sysname
select @s='',@tbname='你的表名'

select @s=@s+' union all select sgybh,ssjr,ssjrq,sbmmc,sfgbh,spzbh,spzmc,sbz,scst1,'
+name+' from ['+@tbname+']'
from syscolumns
where id=object_id(@tbname) and name like 'scs[0-9][0-9]'
set @s=substring(@s,12,8000)
exec(@s)
zjcxc 元老 2004-04-01
  • 打赏
  • 举报
 回复
没看明白.
leeboyan 2004-04-01
  • 打赏
  • 举报
 回复
看不懂啊
lyq 2004-04-01
  • 打赏
  • 举报
 回复
up
zjcxc 元老 2004-04-01
  • 打赏
  • 举报
 回复
select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT=sCsT1,sCs=sCs1 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT2,sCs2 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT3,sCs3 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT4,sCs4 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT5,sCs5 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT6,sCs6 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT7,sCs7 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT8,sCs8 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT9,sCs9 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT10,sCs10 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT11,sCs11 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT12,sCs12 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT13,sCs13 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT14,sCs14 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT15,sCs15 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT16,sCs16 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT17,sCs17 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT18,sCs18 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT19,sCs19 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT20,sCs20 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT21,sCs21 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT22,sCs22 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT23,sCs23 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT24,sCs24 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT25,sCs25 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT26,sCs26 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT27,sCs27 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT28,sCs28 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT29,sCs29 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT30,sCs30 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT31,sCs31 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT32,sCs32 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT33,sCs33 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT34,sCs34 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT35,sCs35 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT36,sCs36 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT37,sCs37 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT38,sCs38 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT39,sCs39 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT40,sCs40 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT41,sCs41 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT42,sCs42 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT43,sCs43 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT44,sCs44 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT45,sCs45 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT46,sCs46 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT47,sCs47 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT48,sCs48 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT49,sCs49 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT50,sCs50 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT51,sCs51 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT52,sCs52 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT53,sCs53 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT54,sCs54 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT55,sCs55 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT56,sCs56 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT57,sCs57 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT58,sCs58 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT59,sCs59 from S_Gy_gysj
union all select sGyBh,sSjr,dSjrq,sBmmc,sFgbh,sPzbh,sPzmc,sBz,sJh,sJx,sGx,sCsT60,sCs60 from S_Gy_gysj
lyq 2004-04-01
  • 打赏
  • 举报
 回复
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[S_Gy_gysj]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[S_Gy_gysj]
GO

CREATE TABLE [dbo].[S_Gy_gysj] (
[sGyBh] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sSjr] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
[dSjrq] [smalldatetime] NULL ,
[sBmmc] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[sFgbh] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[sPzbh] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[sPzmc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sBz] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[sJh] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sJx] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[sGx] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT3] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs3] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT4] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs4] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT5] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs5] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT6] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs6] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT7] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs7] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT8] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs8] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT9] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs9] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT10] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs10] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT11] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs11] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT12] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs12] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT13] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs13] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT14] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs14] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT15] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs15] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT16] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs16] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT17] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs17] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT18] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs18] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT19] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs19] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT20] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs20] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT21] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs21] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT22] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs22] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT23] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs23] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT24] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs24] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT25] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs25] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT26] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs26] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT27] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs27] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT28] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs28] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT29] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs29] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT30] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs30] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT31] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs31] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT32] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs32] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT33] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs33] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT34] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs34] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT35] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs35] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT36] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs36] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT37] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs37] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT38] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs38] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT39] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs39] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT40] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs40] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT41] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs41] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT42] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs42] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT43] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs43] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT44] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs44] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT45] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs45] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT46] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs46] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT47] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs47] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT48] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs48] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT49] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs49] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT50] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs50] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT51] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs51] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT52] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs52] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT53] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs53] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT54] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs54] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT55] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs55] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT56] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs56] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT57] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs57] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT58] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs58] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT59] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs59] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT60] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs60] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

lyq 2004-04-01
  • 打赏
  • 举报
 回复
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[S_Gy_gysj]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[S_Gy_gysj]
GO

CREATE TABLE [dbo].[S_Gy_gysj] (
[sGyBh] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sSjr] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
[dSjrq] [smalldatetime] NULL ,
[sBmmc] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[sFgbh] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[sPzbh] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[sPzmc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sBz] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[sJh] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sJx] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[sGx] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT3] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs3] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT4] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs4] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT5] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs5] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT6] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs6] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT7] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs7] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT8] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs8] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT9] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs9] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT10] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs10] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT11] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs11] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT12] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs12] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT13] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs13] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT14] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs14] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT15] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs15] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT16] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs16] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT17] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs17] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT18] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs18] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT19] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs19] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT20] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs20] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT21] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs21] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT22] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs22] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT23] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs23] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT24] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs24] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT25] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs25] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT26] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs26] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT27] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs27] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT28] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs28] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT29] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs29] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT30] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs30] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT31] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs31] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT32] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs32] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT33] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs33] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT34] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs34] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT35] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs35] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT36] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs36] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT37] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs37] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT38] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs38] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT39] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs39] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT40] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs40] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT41] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs41] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT42] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs42] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT43] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs43] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT44] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs44] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT45] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs45] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT46] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs46] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT47] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs47] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT48] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs48] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT49] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs49] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT50] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs50] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT51] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs51] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT52] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs52] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT53] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs53] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT54] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs54] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT55] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs55] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT56] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs56] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT57] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs57] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT58] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs58] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT59] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs59] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCsT60] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sCs60] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

zjcxc 元老 2004-04-01
  • 打赏
  • 举报
 回复
你直接说你的表结构吧,免得到时表名不对,你又说做不出来.
zjcxc 元老 2004-04-01
  • 打赏
  • 举报
 回复
你提问时的字段名是这样的
scs1(值),scst2,scs2......scst60,scs60


现在的字段名又变成这样:
cst1,cs1....cst60,cs60


当然对应的处理语句也得改啦!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
lyq 2004-04-01
  • 打赏
  • 举报
 回复
好象不对啊
实现如下例：

大至如下：

从列3开始字段名称有规律，为cst1,cs1....cst60,cs60，直到cstX为空为止

列1 列2 列3 列4 列5 列6
一厂 一车间 齿轮 20齿 压辊 30



为:
一厂 一车间 齿轮 20齿
一厂 一车间 压辊 30齿
多媒体教室
当教师在未锁定学生机键盘、鼠标情况下广播或回放时，学生可以利用智能滚动的窗口模式接收广播，此模式可以使学生轻松地跟着教师进行同步操作，边看边练习，使学习由被动转为主动。 教师广播教学和语音教学时允许...
HBASE多行转列冷数据处理
背景及介绍详见：供应链冷热数据处理实践 方案主要包含读写两块，写是第一步，因为PG是行数据，而HBASE是列数据，而且在做数据同步的同时，还要考虑怎样的数据结构可以方便数据读取，不仅仅如此，因为一个主单会...
区块链之实战VM虚拟机开发
栗子详见系列第二篇。Memory合约除了应导出apply函数外，还须要导出memory对象。memory对象是wasm编译器在合约编译时自动注入，通常会开辟一页内存(64KB) (memory $0 1)。解释器会初始化一个线性字节数组作为...
python中转行_Python 把行转为列 ，代码清晰效率高 求高手回答，详见问题补充，谢谢...
展开全部根据你e5a48de588b63231313335323631343130323136353331333335343366给的数据#-*-coding:utf-8-*__author__='eple'importoswithopen('file.txt')asfp:i=0f1=open('temp1.txt','w')f2=open('temp2.txt',...
pyspark rdd中按其中一列分割拆分后转为多行
dataframe也有按某列中按分隔符转成多行的函数，不过dataframe比rdd所需资源更多，所以此处先些rdd的按某列拆分转为多行dataframe的详见https://spark.apache.org/docs/2.3.1/api/python/pyspark.sql.html#...
MS-SQL Server

34,593

社区成员

254,589

社区内容

发帖
与我相关
我的任务
社区描述
MS-SQL Server相关内容讨论专区
社区管理员
  • 基础类社区
  • 二月十六
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章