DataTypes
| Type name | Code | Size | Nullable | Searchable | Scale |
| sql_variant | -150 | 8000 | YES | except LIKE | |
| uniqueidentifier | -11 | 36 | YES | except LIKE | |
| ntext | -10 | 1073741823 | YES | LIKE ONLY | |
| nvarchar | -9 | 4000 | YES | YES | |
| sysname | -9 | 128 | NO | YES | |
| nchar | -8 | 4000 | YES | YES | |
| bit | -7 | 1 | YES | except LIKE | |
| tinyint | -6 | 3 | YES | except LIKE | |
| tinyint identity | -6 | 3 | NO | except LIKE | |
| bigint | -5 | 19 | YES | except LIKE | |
| bigint identity | -5 | 19 | NO | except LIKE | |
| image | -4 | 2147483647 | YES | NO | |
| varbinary | -3 | 8000 | YES | except LIKE | |
| binary | -2 | 8000 | YES | except LIKE | |
| timestamp | -2 | 8 | NO | except LIKE | |
| text | -1 | 2147483647 | YES | LIKE ONLY | |
| char | 1 | 8000 | YES | YES | |
| numeric | 2 | 38 | YES | except LIKE | 0..38 |
| numeric() identity | 2 | 38 | NO | except LIKE | |
| decimal | 3 | 38 | YES | except LIKE | 0..38 |
| money | 3 | 19 | YES | except LIKE | |
| smallmoney | 3 | 10 | YES | except LIKE | |
| decimal() identity | 3 | 38 | NO | except LIKE | |
| int | 4 | 10 | YES | except LIKE | |
| int identity | 4 | 10 | NO | except LIKE | |
| smallint | 5 | 5 | YES | except LIKE | |
| smallint identity | 5 | 5 | NO | except LIKE | |
| float | 6 | 15 | YES | except LIKE | |
| real | 7 | 7 | YES | except LIKE | |
| datetime | 11 | 23 | YES | YES | |
| smalldatetime | 11 | 16 | YES | YES | |
| varchar | 12 | 8000 | YES | YES |