| SPS Home > Dgreath > RDBMS > SQL to VB Datatype Comparison |
SQL to VB Datatype Comparison |
|---|
| DATA_TYPE | SQL Server data type | VB.NET Datatype |
|---|---|---|
| -5 | bigint | Int64 |
| -2 | binary | Byte() |
| -7 | bit | Boolean |
| 1 | char | String |
| 11 | datetime | DateTime |
| 3 | decimal | Decimal |
| 6 | float | Double |
| -4 | image | Object |
| 4 | int | Int32 |
| 3 | money | Decimal |
| -8 | nchar | String or Char() |
| -10 | ntext | String or Char() |
| 2 | numeric | Decimal |
| -9 | nvarchar | String or Char() |
| 7 | real | Single |
| 5 | smallint | Int16 |
| 11 | smalldatetime | DateTime |
| 3 | smallmoney | Decimal |
| -150 | sql_variant | Object |
| -1 | text | String |
| -2 | timestamp | DateTime |
| -6 | tinyint | Byte |
| -11 | uniqueidentifier | Guid |
| -3 | varbinary | Byte() |
| 12 | varchar | String |