TABLE B: Converting VB Data Types to SQL Server Data Types
VB Data Types Corresponding SQL Server Data Type
Long, Integer, Byte, Boolean T-SQL Int
Double, Single T-SQL Float
Currency T-SQL Money
Date T-SQL DateTime
Strings 255 or fewer characters T-SQL VarChar
Strings longer than 255 characters T-SQL Text
One-dimensional byte arrays with 255 or fewer members T-SQL VarBinary
One-dimensional byte arrays with more than 255 members T-SQL Image