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 advantage of ado.net?

970

What is ole db and odbc?

868

What are basic methods of dataadapter?

932

What are the Features of a dataset

1204

Describe datareader object of ado.net with example.

886

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

1028

What are the different ado.net namespaces?

1021

What is the difference between sqldatareader and sqldataadapter?

928

What are datareaders?

929

What is defaultview in datatable?

995

What providers does Ado.net uses?

962

What is a serialized object?

958

What is microsoft ole db provider for sql server?

875

What are the different methods available under the sqlcommand class to access the data?

1008

What are the disadvantages of using datalist?

982