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

diffrence between function and procedure

How to create nested stored procedure?

What is the difference between char and varchar2 datatype in sql?

What are relationships and mention different types of relationships in the dbms

how do we find every fifth record in a table

What is sql or structured query language?

What is the command to change the recovery model?

What are the different ways of moving data/databases between servers and databases in SQL Server?

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

What are the type of joins? When do we use Outer and Self joins?

How to get last system shutdown time in Sql server when restarted system?

What languages bi uses to achieve the goal?

For more SQL Server Interview Questions Click Here