SQL Server @@Error and Raiseerror

Personal Interview - Answers to frequently asked questions Tips to earn promotions and perks 8 things you should NOT do in a Group Discussion How to write a good CV? How to write a good Cover Letter? Tips to become boss's favorite Soft skills every professional must have

By Nishant Kumar

Define @@Error and raiseerror @@Error It is system variable that returns error code of the SQL statement. If no error, it returns zero. @@Error is reset after each SQL statement. Raiseerror Raiseerror command reports error to client application.

NEXT>>

Question: Describe in brief exporting and importing utility?

The Bulk Copy is a command utility that transfer SQL data to or from a data file.
This utility mostly used to transfer huge data to SQL server from other database....

Question: Define Distributed Query and Linked Server?

Distributed Query is a query which can retrieve data from multiple data sources including distributed data........

Question: Define temporary and extended stored procedure.

Temporary Stored Procedure is stored in TempDB database. It is volatile and is deleted once connection gets terminated or server is restarted......

Question: Define Primary and Unique key.

The column or columns of the table whose value uniquely identifies each row in the table is called primary key. You can define column as primary key using primary key constraint while you create table.....

Restricting query result means return of required rows instead of all rows of the table. This helps in reducing network traffic......

Question: Having clause and Where clause

Both are used for filtering of records based on filtered criteria.....

Question: Describe in brief authentication modes in SQL server.

This is the default and recommended security mode. In this mode, access to SQL server is controlled by Windows NT.....