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 user-defined function?
What is ms sql server reporting services?
Are null values the same as that of zero or a blank space?
What are the different editions available in sql server 2000?
What is Sqlpaging in SqlServer 2005 ?
How many triggers are possible per table?
how you can list all the tables in a database?
How to include text values in sql statements?
Explain cursor as data base object?
Write a code to select distinct records without using the DISTINCT keyword.
What stored by the tempdb ? : sql server database administration
How to provide default values to stored procedure parameters?
How to insert stored procedure result into temporary table?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is mean by dml?