Sqlsrver 2005 introduced try-catch block in SQL. orelse you can use Trans

How to Handle the exceptions in Sqlsrver 2005??

Question Posted / manikanta.srinu

Answer Posted / manikanta.srinu

Sqlsrver 2005 introduced try-catch block in SQL. orelse you
can use Transation to Handle error in SQL

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the downside of using udf?

1162

What is snapshot replication?

1099

What is awe?

1079

Is t sql the same as sql server?

1023

How you can get the list of largest tables in a database?

1065

What is the report builder?

143

In which tcp/ip port does sql server run? Can it be changed?

1040

How to execute multiple stored procedures at one time in sql server?

1064

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

1030

Does sql server 2000 clustering support load balancing?

1026

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

1031

What is sql server schema compare? How we can compare two database schemas?

1084

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?

1085

What does top operator do?

1079

What is the difference between nvl and nvl2?

1029