Export (0) Print
Expand All

2.2.5.5.5.3 TDS Type Restrictions

Within a TVP, the following legacy TDS types are not supported:

TDS type

Replacement type

Binary

BigBinary

VarBinary

BigVarBinary

Char

BigChar

VarChar

BigVarChar

Bit

BitN

Int1

IntN

Int2

IntN

Int4

IntN

Int8

IntN

Float4

FloatN

Float8

FloatN

Money

MoneyN

Decimal

DecimalN

Numeric

NumericN

DateTime

DatetimeN

DateTime4

DatetimeN

Money4

MoneyN

Additional types not allowed in TVP:

  • Null type (NULLTYPE:='0x1f') is not allowed in a TVP.

  • TVP type is not allowed in a TVP (no nesting of TVP in a TVP).

  • TDS types should not be confused with data types for a database server that supports SQL.

 
Show:
© 2014 Microsoft