Collections:
Determining Data Types of View Columns in SQL Server
How Column Data Types Are Determined in a View in SQL Server?
✍: FYIcenter.com
When you define a view, its columns are defined through a list of expressions in the underlying SELECT statement. Their data types will be determined implicitly by the expressions.
For example, if the column expression is a column name of a underlying table, the data type of the view column will be the same of the underlying table column.
If the column expression is a function, the data type of the view column will be the function return data type.
If the column expression is an operation, the data type of the view column will be the expression result data type.
The following tutorial exercise shows you some examples of view column data types:
DROP VIEW fyi_links_view; GO CREATE VIEW fyi_links_view (ID, DateString, CountUrl) AS SELECT id, CONVERT(VARCHAR(16), created, 107), CONVERT(VARCHAR(20),counts)+' - '+url FROM fyi_links WHERE counts > 1000 GO SELECT TOP 3 * FROM fyi_links_view; GO ID DateString CountUrl ------ ------------- --------------------------------------- 7600 Jun 06, 1891 237946 - eyfndw jdt lee ztejeyx l q 19437 May 30, 1833 222337 - eypx u x 55924 Dec 29, 1956 1877 - eyq ntohxe i rtnlu riwaskzp c EXEC SP_HELP fyi_links_view; GO Column_name Type Length Prec Scale ------------ -------- ----------- ----- ----- ID int 4 10 0 DateString varchar 16 CountUrl varchar 103
In view, fyi_links_view, defined in this exercise:
⇒ SCHEMABINDING - Binding Views to Underlying Tables in SQL Server
⇐ Assigning New Column Names in a View in SQL Server
2016-11-03, 1423🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...