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

differences between ADO and ADO.NET

1078

What is the difference between Optimistic and Pessimistic locking?

983

What is maximum pool size in ado.net connection string?

976

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

1002

What are the steps you will take to improve performance?

894

What are two types of transaction supported by ado.net?

996

What is ado.net in mvc?

928

Why is stored procedure used in ado.net?

1125

What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

1061

What is ado net stands for?

970

What is a control toolbox?

968

What are the steps to connect to a database?

1024

What provider ado.net use by default? Explain the role of data provider in ado.net?

971

What are dataproviders?

969

How do I delete a row from a DataTable?

1167