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

Explain the dataadapter class in ado.net?

675

What is the role of clr?

539

What do you know about ADO.NET's objects and methods?

528

How to find the given query is optimised one or not?

517

How does entity framework work?

478

What is executenonquery ado.net?

508

What is execute reader in ado.net?

504

What are the advantages of oledb compared with other classes?

2333

What are two important objects of ADO.Net?

562

Explain the namespaces in which .net has the data functionality class.

549

What is the difference between Optimistic and Pessimistic locking?

555

Command objects uses, purposes and their methods.

533

How to retrieve the user id which is provided while windows authentication?

606

Why do we use sqldataadapter?

491

How to work with disconnected data - the dataset and sqldataadapter?

516