Interested to Buy Any Domain ? << Click Here >> for more details...
Without Using Cursors , How to Select the Selected row??
- 3 Answers
- 9069 Views
- CarrizalSoft Technologies, Wipro, I also Faced
- E-Mail Answers
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
What are different type of Collation Sensitivity?
Describe in brief authentication modes in sql server.
Explain triggers?
You want to use a perspective in an mdx query. How do you select the perspective?
What functions can a view be used to performed?
What are the disadvantages of indexes?
What is the difference between update lock and exclusive lock?
What are the indexes in sql server?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Explain about merge replications?
Why it is recommended to avoid referencing a floating point column in the where clause?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
Explain different types of collation sensitivity?
How do I install sql server?
Tell about MOM Tool(Microsoft Operator Manager)?
