Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Without Using Cursors , How to Select the Selected row??

Question Posted / somu.kattikar

Answers were Sorted based on User's Feedback



Without Using Cursors , How to Select the Selected row??..

Answer / somu.kattikar

Using Co-Related Sub Queries

Is This Answer Correct ?    4 Yes 4 No

Without Using Cursors , How to Select the Selected row??..

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

Without Using Cursors , How to Select the Selected row??..

Answer / lalit

shift+space bar

Is This Answer Correct ?    3 Yes 11 No

Post New Answer

More SQL Server Interview Questions

Explain the collation?

0 Answers  

How to store pdf file in sql server?

1 Answers   CarrizalSoft Technologies, College School Exams Tests, TATA,

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 Answers  

why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,

Can you explain the disadvantages/limitation of the cursor?

0 Answers  




Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

0 Answers  

How do I find the sql server database version?

0 Answers  

Give me any three differences between Truncate and Delete.

0 Answers   Genpact,

Explain error handling in ssis?

0 Answers  

What is RAID and what are different types of RAID configurations?

8 Answers   Wipro,

Difference between DELETE and TRUNCATE?

0 Answers   TCS,

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories