What is the difference between views and stored procedures?
Can we have input parameters for views?
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
What are the different subsets of sql?
Tell about MOM Tool(Microsoft Operator Manager)?
Do you know the isolation level that sql server support?
Can you explain what is sql server english query?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
What are the difficulties faced in cube development? : sql server analysis services, ssas
explain databases and sql server databases architecture? : Sql server database administration
Explain syntax for viewing trigger?
if no size is defined while creating the database, what size will the database have? : Sql server administration
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What is 'write-ahead log' in sql server 2000 ?
How to change the password of a login name in ms sql server?
difference between Clustered index and non clustered index ?
What happens if null values are involved in comparison operations?
What is the difference between a fill factor of 100 and 0?