Answer Posted / guest
If we have several tables in a db and we want to view only
specific columns from specific tables we can go for views.
It would also suffice the needs of security some times
allowing specfic users to see only specific columns based on
the permission that we can configure on the view. Views also
reduce the effort that is required for writing queries to
access specific columns every time.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to locate and take substrings with charindex() and substring() functions?
How do you trace the traffic hitting a sql server?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is log ldf?
Explain sub-query?
What should be the fill factor for indexes created on tables? : sql server database administration
Explain log shipping and mention its advantages.
Are connections to sql server encrypted?
Detail about the hardware which is supported by SQL server?
What are the default system databases in sql server 2000?
Find first and last day of current month in sql server
how many type of indexing in database?
What is report subscription?
What is difference between stored procedure and user defined function?
What is coalesce and check constraint in sql server?