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 the use of SCOPE_IDENTITY() function?

in the physical file layout, where should the transaction log be stored in relation to the data file?

What is an execution plan? When would you use it?

What is acid properties?

What do you understand by intent locks?

syntex of insert

What are null values in ms sql server?

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

What do you understand by user-defined function in the sql server?

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

What are the database objects? : SQL Server Architecture

Can you explain the disadvantages/limitation of the cursor?

For more SQL Server Interview Questions Click Here