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.
Popular Posts
-
Cache Callback provides an ability where by some actions can be performed when that item is removed from cache CacheItemRemovedCallback ex...
-
XML DOM loads the entire xml document into memory whereas Simple API for XML ( SAX ) does not load entire xml document into memory XML DOM ...
-
Different types of diagrams in UML : UseCase diagram Class diagram Object diagram State diagram Sequence diagram Collaboration diagram...
-
Virtual-Override and New Class Child inherits from Class Parent and has mehtod ShowVirtualOverride() and ShowNew() methods. Please see th...
-
Question : Name few C# 3.0 enhancements ? Answer : The C# 3.0 language enhancements are as follows: Implicitly typed local variables I...
-
If locaction attribute is specified, must be one of: Any, Client, Downstream, None, Server or ServerAndClient.
Posts
No comments:
Post a Comment