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
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
How many replicas are maintained for each sql azure db?
What is a trace frag? Where do we use it?
What is the difference function and stored procedure?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
What do you mean by tablesample?
What are trace flags and mention a few common trace flags used with sql server?
What are commonly used mssql functions in php?
Which language rdl files made of?
How to convert a numeric expression from one data type to another?
SQL Server Architecture ?
What does COMMIT command do?
How do you create a data source?
Explain syntax for viewing, dropping and disabling triggers?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
