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
How connect excel to sql server?
What are .mdf files?
How to assign new column names in a view?
Can you roll back the ddl statement in a trigger?
How to identify current user in ssrs report?
Do you know exporting and importing utility?
How many databases can we create in a single server?
Differentiate between sql temp table vs table variable?
Can we add our custom code in ssis?
What is proper subset of candidate key?
How to connect of datebase with sql express.?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Explain in brief how sql server enhances scalability of the database system?
How to edit table in sql server 2017?
What are the types of indexes?