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
- 19690 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
Can you pass expressions to stored procedure parameters?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
Mention the differences between sql server and mysql.
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
When would you prefer to have a minimum number of indexes?
What is report snapshot in ssrs?
explain the storage models of olap? : Sql server database administration
What is difference between aggregate and analytic function?
How do I open port 1433?
How can delete duplicate records in cte in sql server?
how you can get the list of largest tables in a database? : Sql server administration
Can you explain what is indexed view? How to create it?
Explain different forms of normalization?
Mention what are the core components of ssrs?
How to configure odbc dsn with different port numbers?
