| 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 |