SQL Server interview questions :- Explain Views and is it possible to update views ?
- By Shiv Prasad Koirala in SQL
- Nov 24th, 2016
- 13575
- 0
Do not miss to watch SQL Server Interview Questions video with sample answers :-
View Is Virtual table over 1 or more physical tables.
There are two types of views :-
1. Simple view :- Simple views are create on single physical base table. Simple views can be updated as they have only one base table internally.
2. Complex view :- Complex views are created on multiple physical tables by using a SQL query. Complex view are readonly and we can not perform DML operation on the same.
Below is a nice video which explains views and also demonstrates nitty gritty about updatable views :-
Shiv Prasad Koirala
Visit us @ www.questpond.com or call us at 022-66752917... read more
- By Shiv Prasad Koirala
- Jun 21st, 2013
- 163239
- 0
.NET interview questions 6th edition (Sixth edition) - By Shivprasad Koirala
- By Shiv Prasad Koirala
- Dec 8th, 2016
- 88968
- 0
Exception Handling in C# using example step by step
- By Shiv Prasad Koirala
- Sep 7th, 2013
- 71871
- 0
