SQL Server Data Type Conversion Chart
binary varbinary char varchar nchar nvarchar datetime smalldatetime date time datetimeoffset datetime2 decimal numeric float real bigint int(INT4) smallint(INT2) tinyint(INT1) money smallmoney bit timestamp uniqueidentifier image ntext text sql_variant xml CLR UDT hierarchyid
Data Type Conversion Chart
Implicit conversions are those conversions that occur without specifying either the CAST or CONVERT function. Explicit conversions are those conversions that require the CAST or CONVERT function to be specified. The following illustration shows all explicit and implicit data type conversions that are allowed for SQL Server system-supplied data types.
To:
From:
binary varbinary char varchar nchar nvarchar datetime smalldatetime date time datetimeoffset datetime2 decimal numeric float real bigint int(INT4) smallint(INT2) tinyint(INT1) money smallmoney bit timestamp uniqueidentifier image ntext text sql_variant xml CLR UDT hierarchyid
Key: Explicit conversion Implicit conversion Conversion not allowed Requires explicit CAST to prevent the loss of precision or scale that might occur in an implicit conversion. Implicit conversions between xml data types are supported only if the source or target is untyped xml. Otherwise, the conversion must be explicit.
? 2012 Microsoft Corporation. All rights reserved. Email: MSPosters@
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- sql server data classification
- sql server data classification tool
- sql server data types
- azure sql server hyperscale
- sql server 2016 string functions
- sql server connection strings
- sql server localhost connection string
- sample sql server connection string
- sql server trusted connection string
- nvarchar data type sql example
- sql server sql syntax
- sql date data type format