what is the purpose of creating view is sql server 2000
Answer Posted / sundaresan
Views are used to select particular columns from a table
which is residing in a different DB. Once views are
crerated we can access the view to get the specified column
details from the table which is present in a different DB
Is This Answer Correct ? | 14 Yes | 4 No |
Post New Answer View All Answers
What is an execution plan?
SQL Server Architecture ?
Explain DBCC?
How to make remote connection in database?
What are the features of Embedded SQL
If user is owning any SQL Objects, can we drop that user
What do you understand by a stored procedure?
What is mapping schema?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Can coalesce return null?
What is the difference between locking and multi-versioning?
Describe in brief sql server monitoring ways.
Does view occupy space?
What do we have to check in database testing?
How to write an inner join with the where clause in ms sql server?