Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain ms sql server reporting services vs crystal reports?
What are different types of roles provided by ssrs?
How to update values in a table with update statements in ms sql server?
What languages bi uses to achieve the goal?
How we can refresh the view?
What is auditing in sql server?
What is the default schema of your login session in ms sql server?
What are audit control procedures?
Explain the steps to create and execute a user-defined function in the sql server?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
How to apply cascading referential integrity in place of triggers?
How do I delete a sql server database?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
how can you check the level of fragmentation on a table? : Sql server administration
How to delete exactly duplicate records from a table?
