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?

Answer Posted / laxman

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

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create an index on a view?

1047


what is isolation level at dead lock?

2132


What is dirty page?

952


What is oltp (online transaction processing)?

982


What is sql server profiler trace data file?

1093


What happens if null values are involved in datetime operations?

956


Can we use having clause without group by?

960


Where are full-text indexes stored?

976


What is the difference between delete and truncate statements?

1059


What are the security related catalog views? : sql server security

932


How do you check sql server is up and running?

973


How do I install only the client tools of sql server 2000?

1042


You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

989


What is fill factor and pad index?

996


How to create nested stored procedure?

999