Mapping Microsoft SQL Server Datatype to XSD Type

Database Type XSD Type
nchar(n) string
datetime string
binary(n) base64Binary
decimal(p,s) double
float double
money double
real double
smalldatetime string
smallint int
smallmoney double
tinyint int
uniqueidentifier string
varbinary(n) base64Binary
bit int
bigint long
datetimeoffset string
date string
varchar(max) string
char(n) string
int int
numeric double
nvarchar string
timestamp base64Binary