Multiple choices 37/50
(Choose 1 answer)
Next
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.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16 17 18
19
20
21 22
23
24
25
26
27
28
29
30
31
32
33
34
35 36 37
38
39
40 41 47
43
44
45 46 47 48
49 50
