IF Boolean_expression { sql_statement | statement_block }
[ ELSE { sql_statement | statement_block } ]
语法
if (condition)
begin
(statement block)
end
else if (condition)
begin
statement block)
end
else
begin
(statement block)
end
实例:
if (select count(1) from Banner where Sort=1 and IsNews=0)!=0
update ...
update ...
这样不行,会报错
if (exists(select count(1) from Banner where Sort=1 and IsNews=0))
update ...
update ...