Interested to Buy Any Domain ? << Click Here >> for more details...
Without Using Cursors , How to Select the Selected row??
- 3 Answers
- 8947 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
List the data types available in mssql?
How to query multiple tables jointly?
What are sql server functions?
Can we deploy SSRS reports on our personal website?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
Explain about nested stored procedure?
Explain left outer join and right outer join?
What are subquery and its properties?
How to download and install microsoft .net framework version 2.0?
Why do we use functions?
How do we know if any query is retrieving a large amount of data or very little data?
explain different types of constraints? : Sql server database administration
Explain hostprotectionattribute in sql server 2005?
How to make a column nullable?
In which files does sql server actually store data?
