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?...
Nesta página do site você pode assistir ao vídeo on-line View in sql server | View | sql server tutorial duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário AJEET iNTbIT 18 Novembro 2022, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 85 vezes e gostou 5 espectadores. Boa visualização!
