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

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

Question Posted / kaumil2001

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

select @@error
select @@rowcount

Is This Answer Correct ?

10 Yes

0 No

More SQL Server Interview Questions

What are the recovery models in sql server 2000?

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

What happens if time-only values are provided as date and time literals?

How to execute multiple stored procedures at one time in sql server?

How to bind a view to the schema of the underlying tables?

What is the maximum rows in sql server table?

What is bit data type?

UPDATE statement can on a single table or on the multiple table?

How do SQL server 2000 and XML linked?

When a primary key constraint is included in a table, what other constraints does this imply?

What are synonyms?

How to list all schemas in a database?

For more SQL Server Interview Questions Click Here