How to Handle the exceptions in Sqlsrver2000

Answers were Sorted based on User's Feedback



How to Handle the exceptions in Sqlsrver2000..

Answer / deepesh jain

@@Error

Is This Answer Correct ?    7 Yes 1 No

How to Handle the exceptions in Sqlsrver2000..

Answer / sisira

you can handle
RAISEERROR

Is This Answer Correct ?    4 Yes 1 No

How to Handle the exceptions in Sqlsrver2000..

Answer / bolisettyvaas

In SQL Server 2000 there is no powerful error handling like
.Net. But you can use one global variable @@ERROR. So after
every dml statement, you can retrieve this variable value
and verify if the value is not equal to 0 then it means some
error occured. otherwise no errors in the last executed
statement.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More ADO.NET Interview Questions

What providers does Ado.net uses?

0 Answers  


What is a sqldataadapter?

0 Answers  


What is executescalar and executenonquery?

0 Answers  


Is ado.net dead?

0 Answers  


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

0 Answers  


OleDbDataAdapter ole=new OleDbDataAdapter(new OleDbCommand ("select * from login",oleDbConnection1)); OleDbCommandBuilder cmd=new OleDbCommandBuilder(ole); ole.Fill(dataSet11,"login"); DataRow drow=dataSet11.Tables ["login"].NewRow(); drow[0]=textBox1.Text; drow[1]=textBox2.Text; drow[2]=textBox3.Text; dataSet11.Tables["login"].Rows.Add (drow); ole.UpdateCommand=cmd.GetUpdateCommand(); ole.Update(dataSet11,"login"); MessageBox.Show("one row added"); this gives exception.how to solve it

1 Answers   Nimaya,


What is the purpose of using adodb?

0 Answers  


Which object needs to be closed?

0 Answers  


what is the syntax code to oledb to connect oracle

6 Answers   IBM,


what are the differences between dataset and datareader?

4 Answers   Choice Solutions,


Define the data provider classes that is supported by ado.net?

0 Answers  


Explain ado.net features? Benefits? Drawbacks?

0 Answers  


Categories