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. Datetimes and intervals are ...

My colleague, senior editor, Kathleen Richards was at MIX08 in Las Vegas two weeks ago. Suffice to say she received a brain dump on Silverlight and a number of other big announcements there. When she ...

Note: The SAS/ACCESS interface does not support the following DB2 data types: BLOB, CLOB, and DBCLOB. specifies a varying-length column for character string data. The maximum length of the string is ...

Building on the DATETIMEFROMPARTS, DATETIME2FROMPARTS offers similar functionality, but yields more precise DateTime2 data type, containing fractions of a second to a specified precision. Naturally, ...

RIGHT JOIN (or RIGHT OUTER JOIN): It’s the opposite of a LEFT JOIN. It keeps all rows from the right table and matches from the left. Less common than LEFT JOIN, but good to know it exists.

Start coding a new database in your garage with a buddy of yours. Use JavaScript. Name it after your dog. Patent your own data model. Do not go open source. Take over the world. That is HarperDB's ...