34,594
社区成员
发帖
与我相关
我的任务
分享
--引用论坛上一兄弟的例子
if exists(select 1 from sysobjects where id=object_id('bm'))
drop table bm
go
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'
print @sql
第二种
if exists(select 1 from sysobjects where id=object_id('bm'))
drop table bm
go
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)
set @sql=‘’
select @sql=@sql+name
from syscolumns where id=object_id('bm')
and name <>'gz'
print @sql