declare @s varchar(100) select @s=coalesce(@s+',','')+name from syscolumns where id=object_id('jobs') and name<>'job_id' exec('select '+@s +' into t from jobs')select * from t别人的给你参考
你可以把语句print出来再贴到视图里面,省得自己写了.declare @s varchar(100) select @s=coalesce(@s+',','')+name from syscolumns where id=object_id('jobs') and name <> 'job_id' print 'select '+@s +' from jobs'
declare @s varchar(100) select @s=coalesce(@s+',','')+name from syscolumns where id=object_id('jobs') and name <> ......
select @s=coalesce(@s+',','')+name
from syscolumns
where id=object_id('jobs') and name<>'job_id'
exec('select '+@s +' into t from jobs')select * from t别人的给你参考
应该没有好的办法了吧!
select @s=coalesce(@s+',','')+name
是什么含义,
select @s=coalesce(@s+',','')+name coalesce 是判断当前字符是否为null ,如果是的话值为表达式2,你把它换为isnull()也一样
select @s=coalesce(@s+',','')+name
from syscolumns
where id=object_id('jobs') and name <> 'job_id'
print 'select '+@s +' from jobs'
select @s=coalesce(@s+',','')+name
from syscolumns
where id=object_id('jobs') and name <> ......