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

Can sql servers link to other servers like oracle?

0 Answers  

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

How except clause is differs from not in clause?

0 Answers  

What is explicit cursors?

0 Answers  

What are constraints in microsoft sql server?

0 Answers  




Can you give an example of Stored Procedure?

4 Answers   Wipro,

What is the purpose of indexing?

0 Answers  

How to get the definition of a trigger back?

0 Answers  

What is the synonym of join?

0 Answers  

How and why use sql server?

0 Answers  

How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  

What is ems sql management studio? : sql server management studio

0 Answers  

For more SQL Server Interview Questions Click Here
Categories