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

difference between Clustered index and non clustered index ?

0 Answers   Infosys,

Write down the syntax and an example for create, rename and delete index?

0 Answers  

How to read 2nd highest sal from EMP table?

5 Answers   IBM, TCS,

How can we get count of the number of records in a table?

0 Answers  

What is explicit cursors?

0 Answers  




What is replication with database mirroring? : sql server database administration

0 Answers  

Explain table valued parameters in sql server? Why tvp used?

0 Answers  

how to find out the repeated value from table using groupby function?

4 Answers  

What is BLOCK statements in SQL?

0 Answers   HCL,

What is the meaning of resultset type_scroll_insensitive?

0 Answers  

What is checkpoint process in the sql server?

0 Answers  

Define Unique Key?

0 Answers   HCL,

For more SQL Server Interview Questions Click Here
Categories