SQL Server: upgrade datetime เป็น datetime2

SELECT
    DB_NAME() AS DatabaseName,
    s.name AS SchemaName,
    t.name AS TableName,
    'ALTER TABLE ' + QUOTENAME(DB_NAME()) + '.' + QUOTENAME(s.name) + '.' + QUOTENAME(t.name) +
    ' ALTER COLUMN ' + QUOTENAME(c.name) + ' datetime2;' AS alter_sql
FROM
    sys.columns AS c
JOIN
    sys.tables AS t ON c.object_id = t.object_id
JOIN
    sys.schemas AS s ON t.schema_id = s.schema_id
JOIN
    sys.types AS ty ON c.user_type_id = ty.user_type_id
WHERE
    ty.name = 'datetime';