What is a view in SQL Server ? How to create one.

A view is a virtual table based on the result-set of an SQL statement. We can create using create view syntax.
CREATE VIEW view_name AS 
SELECT column_name(s)  FROM table_name
WHERE condition

Leave a Comment

Your email address will not be published. Required fields are marked *