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
23675 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

How can I create a new template for import ? : sql server management studio

1022

Is null in sql server?

938

How to drop existing indexes in ms sql server?

1013

Tell me about builtinadministrator?

945

What are pessimistic lock and optimistic lock?

996

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

913

How to override dml statements with triggers?

1069

Explain what is the purpose of sql profiler in sql server?

1004

What is cursors? And what are the different types of cursor?

1084

What is sparse columns of sql server 2008?

991

Explain ms sql server reporting services vs crystal reports?

853

Define self join?

984

How to find the service pack installed? : sql server database administration

970

What is model database in sql server?

1001

State the difference between local and global temporary tables?

1047