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
Where can you add custom error messages to sql server?
What are the advantages of passing name-value pairs as parameters?
Can we delete data from a view?
What is the server name in sql server?
How is sql used in sql server?
What is the New in SQL server 2008?
What are the properties of the relational tables?
Tell me what are the essential components of sql server service broker?
What according to you is the difference between mysql and sql server performance?
Explain filtered indexes?
What are the differences between clustered and non-clustered index?
What are the difference between primary key and unique key? : sql server database administration
Are semicolons required at the end of sql statements in sql server 2005?
Explain the steps needed to create a scheduled job?
How extra digits are handled with numeric data type literals?