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

How to optimize stored procedure optimization?

969

Find first and last day of current month in sql server

1083

What is transactional replication?

1026

What is meant by datasource?

988

How to copy data from one table to another table?

1056

How to handle error or exception in sql?

1040

Name few endpoints exposed by ssrs 2012?

366

What is a performance monitor?

1027

What happens if you are trying to access a schema not owned by you?

1023

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1064

How to create a stored procedure with a statement block in ms sql server?

1133

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

990

New concepts of sql server 2005 use in your project.

2406

How to execute stored procedure in select statement sql server?

1116

What are wait types?

1205