DECLARE @S NVARCHAR(100) DECLARE @S1 NVARCHAR(100) SELECT @S=ISNULL(@S+',','')+NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('TB') AND NAME !=N'COLNAME' SET @S1='SELECT '+@S +' FROM TB' EXEC(@S1)
select * into #tb_c from tb_customer ALTER TABLE #tb_c DROP column status select * from #tb_c通过临时表 ,简单的方法。删除Status
DECLARE @S1 NVARCHAR(100)
SELECT @S=ISNULL(@S+',','')+NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('TB') AND NAME !=N'COLNAME'
SET @S1='SELECT '+@S +' FROM TB'
EXEC(@S1)
ALTER TABLE #tb_c DROP column status
select * from #tb_c通过临时表 ,简单的方法。删除Status