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 are the Features and disadvantages of dataset

550

What are the ado.net connection pooling parameters?

455

What is the use of SqlCommandBuilder?

609

What are the data providers in ADO.NET framework?

583

What is the difference between the clone() and copy() methods of the dataset class?

536

Can datareader hold data from multiple tables?

668

How can we load multiple tables in to dataset?

561

What is dbcontext and dbset in entity framework?

476

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

516

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

522

How can we check that some changes have been made to dataset since it was loaded?

506

describe the dataset object in ado.net.

513

Which provider is used to connect ms access, oracle, etc…?

517

If a table contains 20000 records. In a page at each time 100 records to be displayed.

505

What is ole data type?

496