This post adds one more useful detail: how to preserve the original data types of the columns in your query when using this technique with SQL Server-related sources. Consider the DimDate table in the ...

Shelley Doll finishes her coverage of SQL data types with an overview of datetime and interval data types. Learn more about the basic syntax of these standard SQL types.