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...

Without Using Cursors , How to Select the Selected row??

Answer Posted / nandkumar karlekar

use while loop with #temp table containing auto increment
ID as column

find the row on where ID=@Count
Count ++ up to where ID=@Count not exist.

it is very fast as compair to cursor.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where can you add custom error messages to sql server?

1163


What are the advantages of passing name-value pairs as parameters?

1218


Can we delete data from a view?

980


What is the server name in sql server?

1068


How is sql used in sql server?

1059


What is the New in SQL server 2008?

1017


What are the properties of the relational tables?

928


Tell me what are the essential components of sql server service broker?

987


What according to you is the difference between mysql and sql server performance?

1145


Explain filtered indexes?

1042


What are the differences between clustered and non-clustered index?

1078


What are the difference between primary key and unique key? : sql server database administration

992


Are semicolons required at the end of sql statements in sql server 2005?

1038


Explain the steps needed to create a scheduled job?

982


How extra digits are handled with numeric data type literals?

1031