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

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 / anupom das

3 Answers
5743 Views
I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the use of partition by in sql server?

881

How is SQL Azure different than SQL server?

223

What is correlated subquery in sql server?

1013

Why do we use sql limitations? Which constraints can we use while making a database in sql?

999

How to enter unicode character string literals in ms sql server?

1015

What is unique key constraint?

987

Can we linked SharePoint to a SQL database?

969

What is shared lock?

832

What are the different types of triggers in SQL SERVER?

1047

What is a fill factor?

1031

How to test a dml trigger in ms sql server?

985

Can sql servers linked to other servers like oracle?

901

How to connect Azure federated root database and apply federation in entity framework?

107

How do I create a trace in sql server?

957

How can you insert values in multiple rows using one Insert statement?

1034