To add a new view in a database, use this script written in T-SQL to create a view in SQL Server. A SQL view allows you to display specific columns of an existing table. Think of a view as a virtual table defined by a SQL query selection. It is a set of columns and rows in a table. SQL Server developers create and manage user-defined objects and therefore views.<\/p>\n\n\n\n
Here is an example of a script to create a view in a SQL Server database. Use the SQL Create View statement followed by a Select statement to add a view to a database.<\/p>\n\n\n\n
In addition, there are three different types of SQL Server views:<\/p>\n\n\n\n
On another topic, it can be useful to list all the indexes of a SQL Server database for verification and optimization purposes.<\/p>\n\n\n\n
It can be useful to list all the indexes of a SQL Server database<\/a><\/strong> for double checking and optimisation purposes. <\/p>\n\n\n\n Firstly, let’s consider the Sales table created in a previous article to show different data types available and a simple sales structure to be used in T-SQL examples.<\/p>\n\n\n\n Secondly, with this code, create a view to display part of the table contents. Use the script below and adjust it to the needs of the project.<\/p>\n\n\n\n Then, you can use a Select command like this one, for example to select the second part of the year. That is, the months with a number greater than 6, i.e. from July to December.<\/p>\n\n\n\n Indeed, this short tutorial on SQL Server views explains how to create a view with a script.<\/p>\n\n\n\n To conclude and learn more about MS SQL views, see the definition of SQL views on the dedicated Wikipedia<\/a> page. This time it is the Standard SQL view, applicable to any ISO compliant provider.<\/p>\n\n\n\n Finally, below is an article with an example of a T-SQL script to create a function<\/a><\/strong>.<\/p>\n\n\n\nCreate a SQL Server view with a T-SQL script<\/h2>\n\n\n\n
CREATE TABLE [dbo].[SALES] \n(\n\t[Year] INT, \n\t[MonthName] NVARCHAR(50), -- alphanumeric\n\t[MonthCurrent] BIT, -- Boolean, 0 or 1 , false \/ true\n\t[NumberMonth] TINYINT, -- very small integer, from 0 to 255\n\t[EmployeeNumber] SMALLINT, -- small integer, minimum -2^15, maximum 2^15\n\t[NumberOfClients] INTEGER, -- integer, minimum -2^31, maximum 2^31\n\t[NumberOfSales] BIGINT, -- big integer, minimum: -2^63, maximum 2^63\n\t[Amount_ET] NUMERIC(15,5), -- numeric, 15 digits, with 5 after the comma \n\t[Amount_IT] DECIMAL(15,5) -- decimal, 15 digits, with 5 after the comma\n);<\/pre>\n\n\n\n
CREATE VIEW [dbo].[SalesByMonth] \nAS \nSELECT \n [MonthName], \n [NumberMonth], \n SUM([NumberOfClients]) AS [NumberOfClients], \n SUM([Amount_ET]) AS [Amount_ET], \n SUM([Amount_IT]) AS [Amount_IT] \nFROM [dbo].[Sales] \nGROUP BY \n [MonthName], \n [NumberMonth] \nORDER BY [NumberMonth] ASC;\nGO\n<\/pre>\n\n\n\n
Script to call a T-SQL view from SSMS<\/h3>\n\n\n\n
SELECT \t*\nFROM \t[dbo].[SalesByMonth]\nWHERE \t[NumberMonth] > 6 ;\n<\/pre>\n\n\n\n