Question : Two TSQL statements are executed in below order :
DELETE FROM Employee where EmpID=10
UPDATE Employee set EmpSal = 10000 where EmpID = 15
SELECT @@ERROR
A. @@ERROR will store Error Number of Delete statement
B. @@ERROR will store Error Number of Update statement
Answer : B is correct option
Hint : @@ERROR contains error number of last TSQL statement executed.
No comments:
Post a Comment