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
Answer Posted / shaik
There is no affect in DB while changing in both casess.
| Is This Answer Correct ? | 21 Yes | 5 No |
Post New Answer View All Answers
How to start and end transact-sql statements?
How to execute a sql statement using odbc_exec()?
What is outer join in sql server joins?
What is the difference between a view and a stored procedure?
What is temporary table in sql server? Why we use temp table?
Is sql server is free?
What is the use of floor function in sql server?
What is de-normalization in sql database administration? Give examples?
What is sharding?
What are null values in ms sql server?
What is data source document?
Please explain what is “asynchronous” communication in sql server service broker?
When does a workload on SQL Azure get throttled?
How to create view in stored procedure sql server?
What structure can you implement for the database to speed up table reads?