Overview Constants Conversion Precedence Synonyms Precision, Scale, and Length bit cursor Date and time date datetime datetime2 datetimeoffset smalldatetime time hierarchyid methods GetAncestor (Database Engine) GetDescendant (Database Engine) GetLevel (Database Engine) GetRoot (Database Engine) IsDescendantOf (Database Engine) Parse (Database Engine) Read (Database Engine) GetReparentedValue (Database Engine) ToString (Database Engine) Write (Database Engine) Numeric decimal and numeric float and real int, bigint, smallint, and tinyint money and smallmoney rowversion String and binary binary and varbinary char and varchar nchar and nvarchar ntext, text, and image Spatial geography Spatial geometry sql_variant Table uniqueidentifier XML