954
社区成员
发帖
与我相关
我的任务
分享
IF
(
SELECT COUNT(*) FROM t1
) = 0
BEGIN
SELECT COUNT(*)
FROM t1;
END;
ELSE
BEGIN
SELECT COUNT(*)
FROM t2;
END;
declare @a int
set @a =1
if @a = 1
begin
select 'a'
end
if @a =2
begin
select 'b'
end
这样可以吗?
SELECT IIF(COUNT(*)=0,(SELECT COUNT(*) FROM t1),(SELECT COUNT(*) FROM t2)) FROM t1
SELECT (CASE WHEN COUNT(*)=0 THEN COUNT(*) ELSE (SELECT COUNT(*) FROM t2) END) Count FROM t1
BEGIN
IF (SELECT count(*) FROM t1) = 0
THEN SELECT count(*) FROM t1;
ELSE SELECT count(*) FROM t2;
END IF;
END;
执行报错,IF语法错误。求解