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.

For a wholly numeric one, the kind is 1; for other ones, it's kind 2. When retrieving data that you want to sort, order by the kind of serial, then the serial - e.g. SELECT * FROM tblFoo ORDER BY ...

Ok. I have some tables that store dollar amounts, among other data. I had the fields set to be a data type of money, and was planning on the values including zero. When selecting the data, I was ...

Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.