Converts the specified column using the supplied CONNX Data type, with an optional precision and scale for those CONNX data type that required it.

 

Example:

select

    CastAsCONNXType('PACKED Decimal -> Decimal', numcol, 4, 1) ,

    CastAsCONNXType('Text Date (YYYYMMDD)', stringdate)

from trixie.dbo.test2