Here is the mapping for another SQL database (Netezza). I'd think that the mapping for SQL Server is similar if not the same.
byteint / tinyint
double / numeric
char / varchar
date / timestamp / datetime
Thank you for your response, I believe your answer is accurate.
However, in dataset metadata some date type columns has boolean value for a 'timestampNoTzAsDate" variable. What is the meaning of this?
timestampNoTzAsDate : true