--try declare @str as varchar(2000) set @str='' select @str=id+','+Name+','+convert(varchar(10),Age) from 学生表 where id=1
--如果ID 是整型的,ID也要转换下 --如数据结构如下:declare @t table (id int, name varchar(10),age int) insert into @t select 1,'liuke',20--测试 declare @str as varchar(2000) set @str='' select @str=convert(varchar(10),id)+','+Name+','+convert(varchar(10),Age) from @t where id=1select @str --结果 1,liuke,20(所影响的行数为 1 行)
declare @str varchar(4000), @tablename varchar(40) select @str='', @tablename='syscolumns' select @str='+'',''+'+'isnull(convert(varchar(10), '+name+'), '''')' +@str from syscolumns where id=object_id(@tablename) order by colid desc set @str='select '+stuff(@str, 1,5, '')+' from '+@tablename print @str exec(@str)select isnull(convert(varchar(10), id), ''),* from syscolumns where id=object_id('syscolumns')
declare @str as varchar(2000)
set @str=''
select @str=id+','+Name+','+convert(varchar(10),Age) from 学生表 where id=1
--如数据结构如下:declare @t table (id int, name varchar(10),age int)
insert into @t select 1,'liuke',20--测试
declare @str as varchar(2000)
set @str=''
select @str=convert(varchar(10),id)+','+Name+','+convert(varchar(10),Age) from @t where id=1select @str
--结果
1,liuke,20(所影响的行数为 1 行)
select @str='', @tablename='syscolumns'
select @str='+'',''+'+'isnull(convert(varchar(10), '+name+'), '''')' +@str
from syscolumns
where id=object_id(@tablename)
order by colid desc
set @str='select '+stuff(@str, 1,5, '')+' from '+@tablename
print @str
exec(@str)select isnull(convert(varchar(10), id), ''),*
from syscolumns where id=object_id('syscolumns')