Answer Posted / indraneelandhavarapu

With SQL Server 2005, new error handling has been introduced
with the TRY...CATCH processing. Basically what happens is
when an error occurs the processing in the TRY block stops
and processing is then picked up in the CATCH block.

ERROR_NUMBER() Returns the number of the error
ERROR_SEVERITY() Returns the severity
ERROR_STATE() Returns the error state number
ERROR_PROCEDURE() Returns the name of the stored procedure
or trigger where the error occurred
ERROR_LINE() Returns the line number inside the routine
that caused the error
ERROR_MESSAGE() Returns the complete text of the error
message. The text includes the values supplied for any
substitutable parameters, such as lengths, object names, or
times

Explain the use of keyword with encryption. Create a store procedure with encryption?

961

---

Can you explain different types of joins?

935

---

Explain what are the events recorded in a transaction log?

1004

---

What are the steps to process a single select statement?

942

---

Define primary key?

1138

---

What is @@error in sql?

1064

---

What do you mean by cardinality?

903

---

What is single-user mode?

940

---

What is meant by referential integrity?

1010

---

What are distinctive joins find as a part of sql?

953

---

How can I track the changes or identify the latest insert-update-delete from a table?

961

---

Can you please explain the difference between function and stored procedure?

1007

---

Why normalization is used?

1009

---

How can you set the threshold at which sql server will generate keysets asynchronously?

987

---

Can we hide the definition of a stored procedure from a use?

1224

---