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

What is the full form of ado?

518

What are the advantage of ado.net?

524

What is ole db query?

526

What are all the classes that are available in System.Data Namespace?

561

Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

560

Describe briefly an ADO.NET Dataset ?

555

What is Serialization in .NET? what are the types of Serialization?

557

Which method in OLEDBAdapter is used to populate dataset with records?

563

Why do we need ado.net?

545

What is the difference between oledb sql server and oledbdotnet provider?

508

How can we add/remove row's in "datatable" object of "dataset"?

541

Explain the difference in an abstract class and an interface?

507

Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

459

Give an example that shows how to execute a stored procedure in ado.net?

572

What is the use of SqlCommand object?

649