what is the purpose of creating view is sql server 2000
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
Difference between Sql server reporting services and Crystal reports?
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?
What is t-sql script to take database offline – take database online.
What do you know about system database? : SQL Server Architecture
What is a DBMS, query, SQL?
List few advantages of stored procedure.
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
Mention the different types of replication in sql server.
Define candidate key, alternate key, and composite key.
What Is Rdbms?
What is pivot and unpivot?
What command would you use to create an index?
Define ACID properties in a Database?
What is row-level compre?
Is sql server a database?