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 few of the new features of sql server 2008 management studio

0 Answers  

on line cluster can we make if yes tell me the procedure

0 Answers   Microsoft,

Define ACID properties in a Database?

0 Answers   iNautix,

What is meant by datasource?

0 Answers  

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,




What is the definition for sql server 2000?

0 Answers  

What is replace and stuff function in sql server?

0 Answers  

What is an inner join?

0 Answers  

How to count groups returned with the group by clause in ms sql server?

0 Answers  

How to list all columns in a table using odbc_columns()?

0 Answers  

What types of integrity are enforced by a foreign-key constraint

1 Answers  

How do you set a trace flag in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories