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

could you please reply for these question:
1.About Use Apply?
2.Avoid cursors - When we have a situation that we can not
avoid the use of cursor than what is the alternate solution?
is there anything we can use instead of cursor to perform
the desired task? which optiomize the peroformance too.

3.What is computed columns?

Thanks in advance.

Regards,
Rupesh

Question Posted / senthilsjc

Answers were Sorted based on User's Feedback



could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a sit..

Answer / anupom das

Use Table variable with a identity column. Then make a while
loop row by row

Is This Answer Correct ?    2 Yes 0 No

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a sit..

Answer / anupom das

Use Table variable with a identity column. Then make a while
loop row by row

Is This Answer Correct ?    1 Yes 0 No

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a sit..

Answer / prasanna

Use derived columns,corelated subqueries instead of cursors
so that the performance will also be improved.

Regards
prasanna

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

How to create a new table in a given schema?

0 Answers  

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

3 Answers   CarrizalSoft Technologies, Wipro,

What is table constraint?

0 Answers  

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

0 Answers  




What is a not null constraint?

0 Answers  

Explain primary key, foreign key and unique key?

0 Answers  

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

3 Answers   CarrizalSoft Technologies, IBM,

Explain syntax for disabling triggers?

0 Answers  

how to find nth highest salary

103 Answers   Cognizant, IBM, NexGen, Oracle,

How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

15 Answers   Leo Technologies, Mannar Company, Synechron,

How to swap the data of two columns in a table. both the columns containing varchar values.

9 Answers  

For more SQL Server Interview Questions Click Here
Categories