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 is “asynchronous” communication in sql server service broker?

what is the information that can be stored inside a bit column? : Sql server database administration

What is the default schema of your login session in ms sql server?

What are the different types of collation sensitivity in sql server?

What are indexes in sql?

What is view in sql?

How do I create a partition table in sql server?

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

What is the server name for sql management studio?

What are the new scripting capabilities of ssms? : sql server management studio

can an order by clause be used in a creation of a view?

Â Explain what is sql override for a source taLle in a mapping?

For more SQL Server Interview Questions Click Here