Both Cursors and Views doesn't store data , so their is no chance to a

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 / bindu

5 Answers
23821 Views
I also Faced
E-Mail Answers

Answer Posted / bindu

Both Cursors and Views doesn't store data , so their is no chance to affect the DB.

Is This Answer Correct ?

4 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What xml support does the sql server extend?

990

What is rank function?

1013

What is the default fill factor value?

1063

Please illustrate physical database architecture? : SQL Server Architecture

967

What is the difference between insensitive and scroll cursor?

1137

How does normalization work?

899

What is collation?

1125

How do we know if any query is retrieving a large amount of data or very little data?

954

Do you know what is blocking?

932

What is normalization and denormalization in sql server?

992

What is the correct order of the logical query processing phases?

918

How to rename an existing column with sql server management studio?

982

What is a result set object returned by mssql_query()?

1128

How many types of built in functions are there in sql server 2012?

907

what is the difference between openrowset and openquery?

1068