[fid] [int] NOT NULL , [wjm] [nvarchar] (300) COLLATE Chinese_PRC_CI_AS NOT NULL , [lwjg] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [fwh] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [fs] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [mj] [int] NOT NULL , [swsj] [datetime] NOT NULL , [clyj] [ntext] COLLATE Chinese_PRC_CI_AS NULL , [clyjsj] [datetime] NULL , [cljg] [ntext] COLLATE Chinese_PRC_CI_AS NULL , [cljgsj] [datetime] NULL , [bz] [ntext] COLLATE Chinese_PRC_CI_AS NULL , [fpath] [nvarchar] (300) COLLATE Chinese_PRC_CI_AS NULL , [swh] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [sfjs] [int] NOT NULL , [psqx] [nvarchar] (1000) COLLATE Chinese_PRC_CI_AS NULL , [fjys] [int] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]set @sqlstr='select identity(int,1,1) as Nid,cast(fid as int) fid,wjm,lwjg,fwh,swh,fs,swsj,clyj,clyjsj,cljg,cljgsj,sfjs,psqx,fjys,bz into #temp from tfile '
exec (@sqlstr)select fid,wjm,lwjg,fwh,swh,fs,swsj,clyj,clyjsj,cljg,cljgsj,sfjs,psqx,fjys,bz,case mj when 0 then '普通' when 1 then '机密' when 2 then '绝密' end as mjname from #tempdrop table #temp -----------------------------help !!
[fid] [int] NOT NULL , [wjm] [nvarchar] (300) COLLATE Chinese_PRC_CI_AS NOT NULL , [lwjg] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [fwh] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [fs] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [mj] [int] NOT NULL , [swsj] [datetime] NOT NULL , [clyj] [ntext] COLLATE Chinese_PRC_CI_AS NULL , [clyjsj] [datetime] NULL , [cljg] [ntext] COLLATE Chinese_PRC_CI_AS NULL , [cljgsj] [datetime] NULL , [bz] [ntext] COLLATE Chinese_PRC_CI_AS NULL , [fpath] [nvarchar] (300) COLLATE Chinese_PRC_CI_AS NULL , [swh] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [sfjs] [int] NOT NULL , [psqx] [nvarchar] (1000) COLLATE Chinese_PRC_CI_AS NULL , [fjys] [int] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]set @sqlstr='select identity(int,1,1) as Nid,cast(fid as int) fid,wjm,lwjg,fwh,swh,fs,swsj,clyj,clyjsj,cljg,cljgsj,sfjs,psqx,fjys,bz into ##temp from tfile '
exec (@sqlstr)select fid,wjm,lwjg,fwh,swh,fs,swsj,clyj,clyjsj,cljg,cljgsj,sfjs,psqx,fjys,bz,case mj when 0 then '普通' when 1 then '机密' when 2 then '绝密' end as mjname from ##tempdrop table ##temp
我又改了一下但什么数据也不返回 !!!!!declare @sqlstr char(500)CREATE TABLE #temp (
[fid] [int] NOT NULL ,
[wjm] [nvarchar] (300) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[lwjg] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[fwh] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[fs] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[mj] [int] NOT NULL ,
[swsj] [datetime] NOT NULL ,
[clyj] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[clyjsj] [datetime] NULL ,
[cljg] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[cljgsj] [datetime] NULL ,
[bz] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[fpath] [nvarchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
[swh] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[sfjs] [int] NOT NULL ,
[psqx] [nvarchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[fjys] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]set @sqlstr='select identity(int,1,1) as Nid,cast(fid as int) fid,wjm,lwjg,fwh,swh,fs,swsj,clyj,clyjsj,cljg,cljgsj,sfjs,psqx,fjys,bz into #temp from tfile '
exec (@sqlstr)select fid,wjm,lwjg,fwh,swh,fs,swsj,clyj,clyjsj,cljg,cljgsj,sfjs,psqx,fjys,bz,case mj
when 0 then '普通'
when 1 then '机密'
when 2 then '绝密'
end as mjname
from #tempdrop table #temp
-----------------------------help !!
[fid] [int] NOT NULL ,
[wjm] [nvarchar] (300) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[lwjg] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[fwh] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[fs] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[mj] [int] NOT NULL ,
[swsj] [datetime] NOT NULL ,
[clyj] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[clyjsj] [datetime] NULL ,
[cljg] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[cljgsj] [datetime] NULL ,
[bz] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[fpath] [nvarchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
[swh] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[sfjs] [int] NOT NULL ,
[psqx] [nvarchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[fjys] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]set @sqlstr='select identity(int,1,1) as Nid,cast(fid as int) fid,wjm,lwjg,fwh,swh,fs,swsj,clyj,clyjsj,cljg,cljgsj,sfjs,psqx,fjys,bz into ##temp from tfile '
exec (@sqlstr)select fid,wjm,lwjg,fwh,swh,fs,swsj,clyj,clyjsj,cljg,cljgsj,sfjs,psqx,fjys,bz,case mj
when 0 then '普通'
when 1 then '机密'
when 2 then '绝密'
end as mjname
from ##tempdrop table ##temp