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
- 19674 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
Is it ok to shrink transaction log?
How to optimize stored procedures in sql server?
Explain iaas, paas and saas?
What is resource governor in sql server?
What is the recommended total size of your memory optimized tables?
What is awe?
What are ddl triggers and types of ddl trigger?
How will you go about resolving deadlocks?
Can you get second highest salary from the table?
What is the default order of an order by clause?
What are the rendering extensions of ssrs?
Do you know what is a with(nolock)?
How will you know when statistics on a table are obsolete?
How is SQL Azure different than SQL server?
What to perform pattern match with the like operator?
