Mapping Data Between SQL Type and XSD Type

SQL type	XSD type	Type restrictions
BigInt	xsd:long
Binary	xsd:base64Binary
Bit	xsd:boolean
Char	xsd:string
DateTime	xsd:dateTime
Decimal	xsd:decimal
Float(53)	xsd:double
GUID (same as UniqueIndentifier)	xsd:string
Image	xsd:base64Binary
Int	xsd:int
Money	xsd:decimal
NChar	xsd:string
NText	xsd:string
Numeric	xsd:decimal
NVarChar	xsd:string
Real	xsd:float
SmallInt	xsd:short
SmallDateTime	xsd:dateTime
SmallMoney	xsd:decimal
Sql_Variant	xsd:anyType
Text	xsd:string
TimeStamp	xsd:base64Binary (in SQL Server 2005 or later compatibility mode); xsd:long (in SQL Server 2000 compatibility mode)	8
TinyInt	xsd:unsignedByte
UDT (CLR style)	xsd:base64Binary (in SQL Server 2005)	Additional information about the actual type is provided within facets.
UDT (old style)	Mapped to original base type
VarBinary	xsd:base64Binary
VarChar	xsd:string
XML	xsd:any
XML (typed)	xsd:any	XML schema that the XML is typed to is returned.