DECLARE @STR VARCHAR(8000) SET @STR=''SELECT @STR=@STR+','+NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('tableName') AND NAME<>'编号' ORDER BY COLIDSELECT STUFF(@STR,1,1,'')
通过dbo.syscolumns表 select --方法类似,把一下字段就可以了! declare @sql nvarchar(4000) set @sql=N'' select @sql=@sql+','+ name from dbo.syscolumns(nolocK) where id=OBJECT_ID('spkfk') and name<>'spid' set @sql=STUFF(@sql,1,1,N'') print @sql exec('select '+@sql+N' from spkfk --where......')
select * from spkfk declare @sql nvarchar(4000) set @sql=N'' select @sql=@sql+','+ name from dbo.syscolumns(nolocK) where id=OBJECT_ID('spkfk') and name<>'spid' --spkfk为表名,spid为不需要的列 set @sql=STUFF(@sql,1,1,N'') print @sql exec('select '+@sql+N' from spkfk --where......')
SET @STR=''SELECT @STR=@STR+','+NAME
FROM SYSCOLUMNS
WHERE ID=OBJECT_ID('tableName') AND NAME<>'编号'
ORDER BY COLIDSELECT STUFF(@STR,1,1,'')
select
--方法类似,把一下字段就可以了!
declare @sql nvarchar(4000)
set @sql=N''
select @sql=@sql+','+ name from dbo.syscolumns(nolocK) where id=OBJECT_ID('spkfk') and name<>'spid'
set @sql=STUFF(@sql,1,1,N'')
print @sql
exec('select '+@sql+N' from spkfk --where......')
declare @sql nvarchar(4000)
set @sql=N''
select @sql=@sql+','+ name from dbo.syscolumns(nolocK) where id=OBJECT_ID('spkfk') and name<>'spid' --spkfk为表名,spid为不需要的列
set @sql=STUFF(@sql,1,1,N'')
print @sql
exec('select '+@sql+N' from spkfk --where......')