What is the difference between views and stored procedures?
Can we have input parameters for views?
- 6 Answers
- 18441 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
Explain how to integrate the ssrs reports in application?
What do you mean by tablesample?
Explain Reporting Life Cycle?
What are the advantages of policy management?
What are the built in functions in sql server?
How is table type constraint applied to a table?
How can you hide the sql server instances?
Explain the collation?
What is NOT NULL Constraint in sql server 2012?
Explain syntax for disabling triggers?
What does set rowcount do?
What is hot add cpu in sql server 2008?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
How to create a simple user defined function in ms sql server?
What are the grouping functions?
