Interested to Buy Any Domain ? << Click Here >> for more details...
what is the purpose of creating view is sql server 2000
- 13 Answers
- 22030 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / kumar.t
1. View is logical representation of the table.
2. View is derived from the table.
3. view don't occupy any memory space.
purpose.
1. Security
2. Simplicity of the query.
Another Important Point : view is updatble.
By
Kumar.T
| Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
What is the difference between drop table and truncate table?
Explain rdbms?
Explain about nested stored procedure?
What is forward - only cursors / read only cursor?
Can we use where clause in union?
What is tablesample?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
What is the datatype of rowid?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
Do you know how to send email from database?
What is 3nf normalization?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
Write a query for primary key constraint with identity key word?
How to create user messages with print statements in ms sql server?
What is onf in normalization form?
