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 surrogate key? : sql server analysis services, ssas

Explain powershell included in sql server 2008?

Explain what you mean by 3 tier architecture.

What is use of @@ spid in sql server?

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

What is a transact-sql statement batch in ms sql server?

What is the function of inner join?

What is the default Port No on which SQL Server listens?

If we shrink the Databse and Files, how much size is decreased?

How to create prepared statements using odbc_prepare()?

Can you explain what is indexed view? How to create it?

How to truncate the log in sql server 2012? : sql server database administration

For more SQL Server Interview Questions Click Here