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
- 19495 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
How to retrieve error messages using odbc_errormsg()?
Which are ddl commands?
What is data modeling and Reterminal integrity?
How to connect of datebase with sql express.?
can a database be shrunk with users active? : Sql server administration
Do you know what are various aggregate functions that are available?
What is federation member?
How to change the name of a database user?
What is cross join in sql server joins?
Explain what stored procedure sp_replcounters is used for? : sql server replication
What is a trace frag? Where do we use it?
What are the types of joins in sql?
What is a sql join?
Mention the 3 ways to get a count of the number of records in a table.
What is the federation in sql azure?
