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
-
Answer : WCF belongs to System.ServiceModel
-
Different types of assemblies are : Static and Dynamic assemblies Private and Shared assemblies Single file and Multiple file assemblies ...
-
Authorization is used to determine whether user has access to resource or not. There are two ways to authorize a resource : File authoriza...
-
Operation behaviour are scoped at Operation level. It is used for transaction flow , serialization , parameter handling.
-
Different type of method parameters in C# are : Value Parameter Reference Parameter Output Parameter
-
Abstract class has following features : cannot be instantiated contain abstact methods and properties cannot modify abstract class with s...
-
OOPs concepts that C# supports are : Abstraction : is a process that involves identifying the crucial behavior of an object and eliminatin...
-
Characteristics of well designed normalized database are : Table should have identifier Table should store data for single type of entity...
-
There are five types of contracts : Service Contract Operation Contract Data Contract Message Contract Fault Contract Please refer be...
Posts
No comments:
Post a Comment