Without Using Cursors , How to Select the Selected row??
- 3 Answers
- 8328 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 port 1433 secure?
how to do partition in sqlserver
What is meant by indexing?
How to find the list of fixed hard drive and free space on server?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What is amo? : sql server analysis services, ssas
How do I partition a table in sql server?
What is triggers in ms sql server?
What is the difference between implicit and explicit transaction?
What is a non clustered primary key?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
Explain something about security and SQL Azure?
How to verify the port number of the sql server?
How do I create an extended event in sql server?
What are the 10 characteristics of data quality?
