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 provider being used to access oracle database?

1045

What is the use of ADO.NET and XML web services?

1088

What is the default timeout specified for "sqlcommand.commandtimeout" property?

1104

What are the ado.net connection pooling parameters?

1041

How is entity framework different from ado.net?

1001

What is execute reader in ado.net?

1013

What is a dynaset in access?

1109

What is ado.net connection?

1022

Explain why canot we use multiple inheritance and garbage collector paralelly in .net?

1068

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

1030

Define isolation?

1025

What is ado.net objects?

1010

Explain all the classes those are used for database connections between sql server and asp.net?

1059

What is DataRowCollection?

1151

What is microsoft ado?

1074