建立表test,要查询的列名为wang_cai。
模板:
if exists(select * from syscolumns
where id=object_id('查询表的名称') and name='列名')
begin
如果存在要做的操作;
end
例句:
if exists(select * from syscolumns
where id=object_id('test') and name='wang_cai')
begin
select * from test;
end
当然除了存在,还有不存在的情况
模板:
if not exists(select * from syscolumns
where id=object_id('查询表的名称') and name='列名')
begin
满足条件进行的操作;
end
else
begin
满足条件进行的操作;
end
例句:
if not exists(select * from syscolumns
where id=object_id('test') and name='wang_cai')
begin
select * from test;
end
else
begin
select wang_cai from test;
end