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
- 19270 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
Where are full-text indexes stored?
In which files does sql server actually store data?
What is the maximum size of a dimension? : sql server analysis services, ssas
What does nvl stand for?
Explain active/passive and active/active cluster configurations?
Is it possible to call a stored procedure within a stored procedure?
What is entity data services?
How real and float literal values are rounded?
What is a virtual table in sql?
What is the default port for SQL Server over a firewall?
What is the difference between a view and a stored procedure?
What are logical/boolean operations in ms sql server?
What is the difference RDBMS and Graph Database?
Would you store your query in a ssrs report or a database server? State the reason why?
How many tables can be joined in SQL Server?
