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?...
On this page of the site you can watch the video online View in sql server | View | sql server tutorial with a duration of hours minute second in good quality, which was uploaded by the user AJEET iNTbIT 18 November 2022, share the link with friends and acquaintances, this video has already been watched 85 times on youtube and it was liked by 5 viewers. Enjoy your viewing!
