(Choose 1 answer)
Consider the following Transact-SQL statement fragment from a stored procedure. What happens if an error occurs during the INSERT statement?
INSERT INTO Temp (Col1)
VALUES (@TempVal)
PRINT @TempVal
IF @@error != 0
RETURN 1
ELSE
RETURN 0
...MORE CODE BELOW...
A. The stored procedure continues to execute more code below.
B. The stored procedure exits with a return value of 1.
C. The stored procedure exits with a return value of 0.
D. The stored procedure exits with no return value.
Exit 10
