View Revisions: Issue #7040

Back to Issue
Summary 0007040: Add support for the sql_variant column type (in MS SQL Server)
Revision 2025-08-29 13:23 by pmarzullo
Description Support SQL Server sql_variant data type
Revision 2025-08-30 12:36 by pbelov
Description Add support for the sql_variant column type (in MS SQL Server)
Values of the sql_variant could be of various sub-types and require additional information in the data batch.
Revision 2025-08-29 13:23 by pmarzullo
Steps To Reproduce
Revision 2025-08-30 12:36 by pbelov
Steps To Reproduce CREATE TABLE test_variant(
id INT PRIMARY KEY,
varcol SQL_VARIANT
)

INSERT INTO test_variant (id, varcol) VALUES
    (1, 'Hello World'), -- String
    (2, 123), -- Integer
    (3, 45.67), -- Decimal
    (4, GETDATE()); -- Datetime
Revision 2025-08-29 13:23 by pmarzullo
Additional Information
Revision 2025-08-30 12:36 by pbelov
Additional Information https://learn.microsoft.com/en-us/sql/t-sql/data-types/sql-variant-transact-sql?view=sql-server-ver17