if exists(select id from tablename where id = value)
begin
select id from hrmresource where id = value
end
else
select 0 as id
sql查询语句没有结果时赋值为0
最新推荐文章于 2024-04-18 23:42:22 发布
if exists(select id from tablename where id = value)
begin
select id from hrmresource where id = value
end
else
select 0 as id