Without Using Cursors , How to Select the Selected row??
- 3 Answers
- 7880 Views
- CarrizalSoft Technologies, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
How do I uninstall sql server 2014?
Do you know sql server 2008 introduces automatic auditing?
What are the restrictions that views have to follow?
What stored procedure would you use to view lock information?
What is 3nf normalization form?
how can you attach more than 20 ldf files in sql server
What is field with example?
Why we should not use triggers?
Explain primary key in sql server?
Mention the different authentication modes in sql server.
How to end a stored procedure properly in ms sql server?
Differentiate between a primary key and a unique key.
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
