Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of using views. Why do we need
views when we have SPs?
- 4 Answers
- 16368 Views
- 247Customer, I also Faced
- E-Mail Answers
Answer Posted / saurabh
View are the image of table.
advantages:- 1> they hide the details of table from which
they get data.
2> they are working as table and, provide security from
unautherized acccess.
3> they are read only.
4> they update automatically when some changes occurs in
original table
| Is This Answer Correct ? | 23 Yes | 3 No |
Post New Answer View All Answers
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
What is “asynchronous” communication in sql server service broker?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Explain something about security and SQL Azure?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
what types of replication are supported in sql server? : Sql server database administration
What is trigger explain with program?
Can we linked SharePoint to a SQL database?
How do you test your database? : sql server database administration
how many triggers you can have on a table? : Sql server database administration
What is index fragmentation in ms sql server?
What is the distinction amongst delete and truncate?
Tell me extended events in sql server 2008?
Characterize join and name diverse sorts of joins?
