你保证一行的数据类型都是可以加的吗?
declare @sql varchar(1000)
set @sql=''
select @sql=@sql+'+'+rtrim(name) from syscolumns
where id=objectid('a')
set @sql=right(@sql,len(@sql)-1)
exec ('select '+@sql+' as result from a')
。这样的语句只能拿来玩的
declare @sql varchar(1000)
set @sql=''
select @sql=@sql+'+'+rtrim(name) from syscolumns
where id=objectid('a')
set @sql=right(@sql,len(@sql)-1)
exec ('select '+@sql+' as result from a')
。这样的语句只能拿来玩的
set @s = ''select @s = @s + '+' a.name from syscolumns a,sysobjects b
where a.id = b.id and b.name = 'table' and a.xtype in(56,59,60,62,106,108,127)
exec('select '+@s +' from table')