if not exists(select 1 from tb_1 where [email protected])
...
else
...
tb是动态的，如tb_1,tb_2，要把如上语句写成动态，怎么弄？
------解决方案--------------------
declare @sql varchar(8000)
declare @num int
set @sql = 'select '[email protected]+ ' count(1) from '[email protected]+ ' where id= '[email protected]
if @num=0
...
else
...
------解决方案--------------------
lz的若干table原自哪里