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

List out different types of normalizations in sql server and explain each of them?

922

---

What is partition in sql server?

1033

---

Can we take the full database backup in log shipping?

939

---

What do you understand by user-defined function in the sql server?

947

---

How to fine-tune reports?

266

---

Tell me about joins in database system and explain each in detail.

1042

---

How many categories of functions based their return modes?

1101

---

How many databases can we create in a single server?

207

---

Explain system views?

1079

---

What were the latest updates to SQL Azure service?

111

---

What are the export options of ssrs?

173

---

What is simple indexing method?

1017

---

How to check table values in sql server?

952

---

How to use "begin ... End" statement structures in ms sql server?

1033

---

How to insert stored procedure result into temporary table?

1013

---