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
What is replication and database mirroring?
What is inline table-value user-defined function?
In what version of sql server were synonyms released?
What is the difference function and stored procedure?
what is checksum in sql server.........???
Can we do dml on views?
List some case manipulation functions in sql?
What is the function of inner join?
What is server-level principal?
Does an index slow down updates on indexed columns?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Explain DBCC?
What number aggregate functions are accessible there in sql?
How can you hide the sql server instances?
What is a trace frag? Where do we use it?
