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

What happens if you add a new index to large table?

930

What is report server project?

147

what protocol both networks use? : Sql server database administration

966

Explain partitioned view?

1064

what purpose does the model database serve? : Sql server database administration

966

What is instead of dml trigger?

995

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

985

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2740

What is the difference between the 2 operating modes of database mirroring?

1101

Tell me what is a linked server?

1034

what is the different types of backups available in sql server? : Sql server database administration

918

How do I find sql server instance name?

956

What is page in sql server?

941

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1046

What is replication with database mirroring? : sql server database administration

1067