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 can you get @@error and @@rowcount at the same time?

Answer Posted / binoo tiku

@@error variable shows the error number of the last
T-SQL error

@@rowcount variable gives the number of rows affected by
the most recent SQL statements.

Is This Answer Correct ?    9 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1082


What is the simplest way to create a new database in ms sql server?

999


What does dml stand for?

941


Explain primary key and foreign key constraints?

1017


How to convert numeric expression data types using the cast() function?

1055


Do you know the cursor optimization tips?

972


What is an indice?

1022


What are difference between Cluster index and Non-Cluster index?

1064


What factors you will consider calculating the storage requirement for that view?

936


application server is slow what may be the problem

2210


How to create function without parameter in sql server?

1046


Explain system functions or built-in functions? What are different types of system functions?

964


What are the export options of ssrs?

173


How do I create a trace in sql server?

1023


What are the High-Availability solutions in SQL Server and differentiate them briefly?

1134