Interested to Buy Any Domain ? << Click Here >> for more details...
Without Using Cursors , How to Select the Selected row??
- 3 Answers
- 9118 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
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What are system databases into sql server (2005/2008)?
what is a schema in sql server 2005? : Sql server database administration
What are the options which must be set to allow the usage of optimistic models?
What does <> symbol mean?
What is code near application topology?
Which are the new data types introduced in sql server 2008?
How many types of stored procedures are there in sql server?
When would you prefer to have a minimum number of indexes?
How to create a view using data from another view?
What is the data type of time?
What is user-defined functions? What are the types of user-defined functions that can be created?
How to convert a numeric expression from one data type to another?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
