Change in view would not reflect chg in db but in cursor it would.

1.what is the difference between view and cursor?

2.If we do any change in view will it affect the
database,similarly when we do changes in cursor will it
affect the databse?with certain example?Thanks

Question Posted / avinash

5 Answers
23853 Views
I also Faced
E-Mail Answers

Answer Posted / avinash

Change in view would not reflect chg in db but in cursor it
would.

Is This Answer Correct ?

5 Yes

32 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can I disable or restrict ssrs export formats (rendering formats)?

150

ow to bring suspect mode datbase online from scratch

1800

What does COMMIT command do?

1051

What samples and sample databases are provided by microsoft?

1030

Difference between DELETE and TRUNCATE?

1045

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1157

How to create an index on an existing table in ms sql server?

975

Determine when to use stored procedure to complete sql server tasks?

1047

How do I edit a stored procedure in sql server?

916

Differentiate between delete and truncate.

1054

How to create a simple stored procedure in ms sql server?

1022

How sql server executes a statement with nested subqueries?

1021

How to compare the top two records using sql?

1338

What is filestream?

991

Is it possible to update the views? If yes, how, if not, why?

1018