select @@error'Error' select @@rowcount'Rows'

How do you find the error, how can you know the number of
rows effected by last SQL statement?

Question Posted / chandra rekha

Answer Posted / chandra rekha

select @@error'Error'
select @@rowcount'Rows'

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we update data in a view?

972

Tell me what are cursors and when they are useful?

909

Explain system rowset functions?

940

How can you control the amount of free space in your index pages?

1012

How many null values we can have in a unique key field in sql server?

905

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1453

What is a constant or literal in ms sql server?

995

Explain the creation and execution of a user-defined function in the sql server?

998

Explain the properties of sub-query in sql server?

956

how you can deploy an ssrs report?

172

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1070

What is sql server profiler trace data file?

1052

How to add a new dsn with the odbc driver for sql server?

1011

please differentiate between delete and truncate?

944

What is difference between oltp and olap?

983