Answers for "sql server use a view"

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];