Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between views and stored procedures?
Can we have input parameters for views?
- 6 Answers
- 19527 Views
- I also Faced
- E-Mail Answers
Answer Posted / sandeep
At times, the database administrator might want to restric access of data to different users. They
might want some user to be able to access to all columns of a table wheras other users to be able to access only selected columns.The sql server allows you to create views to restric user access to the data.Views also help in simplifying query execute when the query involves retrieving data from maltiple tables by applying joins.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to make a remote connection in a database?
What is explicit cursors?
Explain in brief how sql server enhances scalability of the database system?
What are the dis_advantages of stored procedures, triggers, indexes?
What is transaction server isolation?
What function does a database engine serve in the sql server?
What is data modeling and Reterminal integrity?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
How to write an inner join with the where clause in ms sql server?
When is update_statistics command used?
What is the maximum row of a size?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
Explain few examples of stored procedure over triggers?
What are the advantages of the mirroring?
What is in place upgrade in sql server?
