sql server 查询一张表，假如id=0时执行一条查询语句，id！=0时执行另一条查询语句。需要将id传给两条查询

Question

如题所述

Answer 1

DECLARE @ID INT
SET @ID=??--传进来参数
IF @ID =0
BEGIN
SELECT * FROM TABLE1 --查询语句1
END
ELSE
BEGIN
SELECT * FROM TABLE2 -- 查询语句2
END

参考资料：1

Answer 2

用if判断可以
IF 条件表达式

BEGIN

SQL语句

END

ELSE

BEGIN

SQL语句

END

Answer 3

select * from tablename where id=0
union
select * from tablename where id<>0

Answer 4

if(id<>0)
select * from tb where
else
select * from tb where

Answer 5

select * from tablename where id=0
union
select * from tablename where id<>0本回答被提问者采纳