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 download
- sql server cheat sheet
- how to convert sql from the microsoft sql server database
- migrating mysql to sql server 2014 and azure sql db
- sql workshop washington university in st louis
- entity attribute value eav the antipattern too great to
- vfp conversion to support sql server backend
- azure data warehouse as a service dwaas
- here is the crib sheet study notes i used for the three
- sql server data type conversion chart
- t sql data types
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