if @@ERROR>0 then begin 'Error Block end

When we are running the Application, if any errors occur in
the Stored Procedure then how will the server identify the
errors?

Question Posted / sivakumar m

Answer Posted / sivakumar m

if @@ERROR>0 then
begin
'Error Block
end

Is This Answer Correct ?

3 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Command objects uses, purposes and their methods.

704

Describe briefly an ADO.NET Dataset ?

729

Define partial class?

722

What are dataproviders?

721

What are the connected and disconnected modes in ado.net?

686

What is dataadapter in ado.net?

684

Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

736

Explain the difference in an abstract class and an interface?

694

Which object is used to add relationship between two Datatables?

773

What is dataset and datatable in ado.net?

702

What are the differences between OLEDB and SQLClient Providers?

760

How to identify the controls which can be used for binding data?

741

What is difference between datatable and dataset?

728

What is the role of data provider in ado.net?

731

What are different layers of ADO.Net?

788