View in sql server | View | sql server tutorial
View in Sql Server
View is a virtual table or imaginary table
*we can create view(s) after creating the table only
*View is a database object which resides in Database Server and stores only select query in compiled format. Hence view is also called as stored Query
By using View(s) we can provide:
1. Security
2. we can reduce network traffic by using view(s)
3. we can improve the performance of the query
Views are of 2 types:
1. Simple View
2. Complex View
1.Simple View : A view which is created on single table is called as Simple view
*syntax for creating a view
create view viewName
As
SelectQuery
Q.can we insert the records into View
Ans Y
2.Complex view(s):A view(s) which is applied on multiple tables is called a Complex view(s).
#sql
#sqlinterview
Please Follow me on all Social Network,
Instagram Link: / technicalk903
Facebook Link: https://www.facebook.com/profile.php?...
En esta página del sitio puede ver el video en línea View in sql server | View | sql server tutorial de Duración hora minuto segunda en buena calidad , que subió el usuario AJEET iNTbIT 18 noviembre 2022, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 85 veces y le gustó 5 a los espectadores. Disfruta viendo!
