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

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

Security Question- SQL DBA exparts, need your help...

What is 1nf normalization form?

how to rest identity columns in sql server

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

wht's the differece between sqlserver05 and sqlserver2000

How are the exceptions handled in sql server programming?

How many types of cursors are there in SQL Server?

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

What is SQL Server?

What do you mean by data manipulation language?

What is a trigger in sql server?

For more SQL Server Interview Questions Click Here