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?...
In questa pagina del sito puoi guardare il video online View in sql server | View | sql server tutorial della durata di ore minuti seconda in buona qualità , che l'utente ha caricato AJEET iNTbIT 18 novembre 2022, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 85 volte e gli è piaciuto 5 spettatori. Buona visione!
