view in sql server
/* A view is created with the CREATE VIEW statement. */
CREATE VIEW view_name AS
SELECT column1, column2, ...
FROM table_name
WHERE condition;
/*example*/
CREATE VIEW [Brazil Customers] AS
SELECT CustomerName, ContactName
FROM Customers
WHERE Country = 'Brazil';
/*query*/
SELECT * FROM [Brazil Customers];