DECLARE @Temp nvarchar(1050)='' SELECT CAST(SQL_VARIANT_PROPERTY(@Temp, 'BaseType') AS VARCHAR(50))SELECT CAST(SQL_VARIANT_PROPERTY(@Temp, 'MaxLength') AS VARCHAR(50))