Answer Posted / neetu

In SQLSERVER 2005 exceptions are handle by using RaisError
with Try catch like in other prog languages.
Begin Try

End try

Begin Catch

End Catch
BEGIN TRY

RAISERROR ('Yaa, I ma the problem', 16,1)

END TRY



BEGIN CATCH

SELECT ERROR_NUMBER() as ERROR_NUMBER,

ERROR_SEVERITY() as ERROR_SEVERITY,

ERROR_STATE() as ERROR_STATE,

ERROR_MESSAGE() as ERROR_MESSAGE

END CATCH



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.

What is the xml datatype?

993

---

Where the sql logs gets stored? : sql server database administration

917

---

What is resource governor?

927

---

Tell me what is sql profiler?

982

---

What happens when converting big values to integers?

959

---

what is datawarehouse?

1056

---

When is the use of update_statistics command?

953

---

What are the steps to follow to configure SQL*Net?

995

---

What is the difference between char, varchar and nvarchar?

980

---

What is SQL Azure?

105

---

How to execute a sql statement using odbc_exec()?

1061

---

What extended events?

955

---

How to delete duplicate rows in sql server?

1058

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

978

---

What is left outer join in sql server joins?

970

---