declare @s varchar(500),@sql varchar(4000)
select @s=isnull(@s+',','')+name from sys.columns
where object_id = object_id('表名','U')
and name !='字段名'
declare @s varchar(500),@sql varchar(4000)
select @s=isnull(@s+',','')+name from sys.columns
where object_id = object_id('表名','U')
and name !='字段名'