sql语句:if exists语句使用
if exists(select * from test.dbo.test1 where a='1') begin print('exists ') end else begin print('no exists ') end go
if exists(select * from test.dbo.test1 where a='1') begin print('exists ') end else begin print('no exists ') end go