Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

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

What are the different ways you can create databases in sql server?

0 Answers  


What do you mean by stored techniques? How would we use it?

0 Answers  


Can group functions be used in the order by clause in ms sql server?

0 Answers  


Explain the steps to create and execute a user-defined function in the sql server?

0 Answers  


When we should use @@error?

0 Answers  


to explain sql server 2000 architecture & authentication

1 Answers   HCL,


What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

3 Answers   TCS,


Can another user execute your local temporary stored procedures?

0 Answers  


why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

0 Answers  


What are mdf,ndf,ldf files and how to see the data in those files?

6 Answers   Accenture,


Explain about nested stored procedure?

0 Answers  


Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,


Categories