满足case条件时执行insert语句

if case

if @test1=0 and @test2=0 and @test3=0 
begin 
    {Insert statement} 
end;
Else if @test1=0 and @test2=0 and @test3=1
begin
    {select “All cases should be 0”}
end
Else
begin
    Select “Please provide date”
end;

IF 0 COALESCE NULLIF

IF (@test1 = 0 AND @test2 = 0 AND @test3 = 0) 
BEGIN 
    INSERT INTO tmpTable(val1)
    SELECT val1 FROM <table_name>
END
ELSE IF COALESCE(NULLIF(@test1, 0), NULLIF(@test2, 0), NULLIF(@test3, 0)) IS NOT NULL
BEGIN
    SELECT 'All cases should be 0'
END
ELSE
BEGIN
    SELECT 'Please provide data'
END