SQL Server Errors Question:

Download Job Interview Questions and Answers PDF

What is sqlcode -922 & -923?

SQLServer Errors Interview Question
SQLServer Errors Interview Question

Answer:

Reason why SQLcode -922 generated:

Authorization failed because of the error indicated by error-type

It can be any of the following..

* User authorization.
* Plan access
* connect
* Installation error
* Duplicate exit requested.

Reason code: DB2® reason code associated with authorization failure

Download SQLServer Errors Interview Questions And Answers PDF

Previous QuestionNext Question
In one table there is 10 records without id num, without primary key and it is not sorted then how to extract last 6 record from table?How to select particular number using rownum?
Example: i need only the second max number using rownum?