what is the purpose of creating view is sql server 2000
- 13 Answers
- 19348 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / thirumal
View is used to fetches the data from existing table and it
doesn't occupy any space in memory.
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
What is data compression?
How to get a list of columns in a view using the "sp_help" stored procedure?
What are the different types of lock modes in sql server 2000?
Which sql server table is used to hold the stored procedure script?
What is difference between drop truncate and delete?
What are various limitations of the views?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
What is a functions and types in sql server?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Explain use of expression builder.
Explain the truncate command? : SQL Server Architecture
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What is command parameter in ssrs?
How to insert stored procedure result into temporary table?
What is logshipping and its purpose?
