34,571
社区成员
发帖
与我相关
我的任务
分享
declare @sql varchar(8000)
select @sql=isnull(@sql+',','')+name
from syscolumns where id=object_id('AAA')
and name <>'c'--不需要的列
exec(' select '+@sql+' from AAA')
if exists(select 1 from sysobjects where id=object_id('bm'))
drop table bm
CREATE TABLE bm(bmid int,bmname varchar(10) ,username varchar(10) ,hpmc varchar(10) ,gz int)
insert into bm select 1,'销售一部','小张','货品A',1000
insert into bm select 2,'销售二部','小王','货品B',3000
insert into bm select 3,'销售三部','小乐','货品C',2000
insert into bm select 4,'销售四部','小马','货品D',1000
declare @sql varchar(8000)
select @sql=isnull(@sql+',','')+name
from syscolumns where id=object_id('bm')
and name <>'gz'--不需要的列
exec(' select '+@sql+' from bm')
select * from bm