Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
You have noticed that a particular block of Transact-SQL code triggers Error 1105. You want to determine the error state number of that particular error. You configure the appropriate TRY . . . CATCH construct.
Which of the following system functions can you use to determine this information?
on 6/30/2013 | Category:
Sql Server Interview questions
| Views: 1169 |
Select from following answers:
ERROR_STATE() system function to determine the error state number. An error state number differs from an error number. For example, the 1105 error can have a state of 0, 1, 2, or 3.
Show Correct Answer
measureup.com | |
< Previous :
You are optimizing several complex queries. You ha ...
Next > :
An error occurs when you execute a block of Transa ...
Comments or Responses
Login to post response
More Interview Questions by Rajkatie
An error occurs when you execute a block of Transact-SQL code, causing ...
You are working with some T-SQL code that causes an error. You want to ...
An error occurs when you execute a block of T-SQL code, causing a tran ...
An error occurs when you execute a T-SQL code. You configure the appro ...
You want to find out the specific line in a block of T-SQL code that c ...
You want to ensure that statements in the transaction can read rows al ...
You want to ensure the following: *Statements in a particular trans ...
You want to ensure the following: 1) Data read by any statement in ...
Latest Interview Questions
In.Net which is the parent class to create all windows service?
What is infonomics?
how to change the database owner?
What is the maximum size of columns in a particular table?
How to convert server name to host name?
How can you detect the servername ?
How can you detect the host name and Ip address?
How can you detect the version properties?