Without Using Cursors , How to Select the Selected row??
- 3 Answers
- 8088 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
Is there any difference between the primary key and unique key?
What is transact-sql ddl trigger?
What is the difference RDBMS and Graph Database?
How are the unique and primary key constraints different?
Which rendering formats are affected by the pagesize properties?
Explain different types of locks in sql server.
what is unique and xaml nonclustered index
What is global temp table?
What is indexing and its types?
What are different types of views?
What is the purpose of sql profiler in sql server? : sql server database administration
How to perform backup for certificates in sql server? : sql server security
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
How can I get data from a database on another server?
What is the difference between function and stored procedure in sql server?
