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:
2016-11-03, 696👍, 0💬
Popular Posts:
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To Provide Values to Stored Procedure Parameters in SQL Server Transact-SQL? If a stored procedu...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To Create a Stored Function in Oracle? A stored function is a function with a specified name and...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...