WHAT IS VIEW IN SQL SERVER ?HOW MANY TYPES OF VIEW AVAILABLE?

 Posted by Sriramnandha on 5/23/2012 | Category: Sql Server Interview questions | Views: 3793 | Points: 40
Answer:

VIEW IS AN VIRTUAL TABLE.VIEW IT WONT OCCUPY ANY MEMORY,VIEW IS AN IMAGINARY TABLE.
VIEW CANNOT INSERT,UPDATE ,DELETE STATEMENTS

THERE TWO TYPES OF VIEWS AVAIALBLE

1) SCHAMABINDING
2) ENCRYPTION

REGARDS


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response