DBI202_-_SU_2023_-_Block_5_-_FE_729.webp
lanhong87

DBI202_-_SU_2023_-_Block_5_-_FE_729.webp

(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 @TempValIF @@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 34

Thông tin

Category
DBI202
Thêm bởi
lanhong87
Ngày thêm
Lượt xem
3,560
Lượt bình luận
29
Rating
0.00 star(s) 0 đánh giá

Image metadata

Filename
DBI202_-_SU_2023_-_Block_5_-_FE_729.webp
File size
56.7 KB
Dimensions
1542px x 690px

Share this media

Back
Bên trên Bottom