Answers for "view in sql server"

SQL
2

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];
Posted by: Guest on September-23-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language