| BEGIN - END | BEGIN - END |
|---|
subject:BEGIN - END
syntax:BEGIN { sql_statement | statement_block } END
content:ชุดคำสั่งภายใน Stored 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