what is the purpose of creating view is sql server 2000
Answer Posted / veena
Views can reduce the complexity of database schema
Veiw can provide column level and row level security
By using views present aggregated data and hide detailed data
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is mscorsvw.exe - process - microsoft .net framework ngen?
How do I find the port number for sql server?
What are scalar functions in sql?
What is the difference between substr and charindex in the sql server?
Explain the ways to controlling cursor behavior?
Do you know sql server 2008 backup compression?
Explain difference between control flow and data flow?
What are the key configuration files for sql server reporting services ?
What are parameterized reports?
What is tabulation?
What command do we use to rename a database?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
How does Report Builder support Analysis Services cubes?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What is SQL Server?