Interested to Buy Any Domain ? << Click Here >> for more details...
Without Using Cursors , How to Select the Selected row??
- 3 Answers
- 9127 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
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is nolock?
Can we deploy SSRS reports on our personal website?
What are the steps you must follow to hide sql server instances?
What are the properties of primary key?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
What is acid properties?
how to do partition in sqlserver
What is cursors? And what are the different types of cursor?
Can you explain important index characteristics?
What stored procedure can you use to display the current processes?
Which language rdl files made of?
What is a data source file?
What is difference between standardization and normalization?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
