| IF - ELSE | IF - ELSE |
|---|
subject:IF - ELSE
syntax:IF boolean_expression { sql_statement | statement_block } ELSE { sql_statement | statement_block }
content:คำสั่งแบบมีเงื่อนไขที่ใช้ใน Stroed Procedure
example:CREATE PROCEDURE up_sum @value_1 int, @value_2 int, @value_3 int, @result int output AS BEGIN SELECT @result = @value_1 + @value_2 + @value_3 IF @result < 0 @result = 0 ELSE @result = @result * 10 END
