1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How do you find the error, how can you know the number of
rows effected by last SQL statement?

Question Posted / guest

Answers were Sorted based on User's Feedback



How do you find the error, how can you know the number of rows effected by last SQL statement?..

Answer / chandra rekha

select @@error'Error'
select @@rowcount'Rows'

Is This Answer Correct ?    4 Yes 0 No

How do you find the error, how can you know the number of rows effected by last SQL statement?..

Answer / laxman

select @er=@@error,@rc=@@rowcount

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More SQL Server Interview Questions

HOW TO RENAME A COLUMN NAME

3 Answers  

What is the use of tempdb? What values does it hold?

0 Answers   Abacus,

How can we get count of the number of records in a table?

0 Answers  

how many types of store procedre in sqlserver 2000?

2 Answers   ATI,

What is the new security features added in sql server 2014? : sql server security

0 Answers  




Distinguish between nested subquery and correlated subquery?

0 Answers  

Explain difference between control flow and data flow?

0 Answers  

what is bit data type? and what are the information that can be stored inside a bit column?

2 Answers  

What is the diff between Dynamic queries and static queries

1 Answers   CGG, ICS Integrated Computer Solutions,

What is logon trigger?

0 Answers  

What is the difference between rank and dense_rank?

0 Answers  

How to enable/disable indexes?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories