what is the purpose of creating view is sql server 2000
Answer Posted / parmanand
Not all the views are updatable. updatable viwes are
available from SQL Sever 2000 version.
Pls remember all the views are not up datable again.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How many types of the database links?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What is user-defined function?
How many triggers are possible per table?
Do you know what is difference between stored procedure and user defined function?
Mention the different types of triggers?
what does the automatic recovery do? : Sql server administration
What is the correct order of the logical query processing phases?
What is coalesce in sql server?
What number aggregate functions are accessible there in sql?
How to loop through returning rows?
What are the different types of backups that exist?
What is the significance of null value and why should we avoid permitting null values?
How to get a list of columns in a view using "sys.columns" in ms sql server?
How to create sub reports?