Tag: SQL

  • Get List of Tables and Creation Date from SQL Server

    Getting information from the SQL Server system tables is relatively easy and can be a great way of checking whether you completed some task or whatever. I use the following query or some variant to see when I’ve done something or what I named it or whatever. SELECT name, create_date FROM sys.tables order by create_date

  • Book Review: SQL Pocket Guide

    SQL Pocket Guide by Jonathan Gennick is a small pocket sized guide published by O’Reilly. The book isn’t really meant to be a learning guide and more of a quick memory refresher for something not commonly used. There’s very little fluff in the this small tome on the different SQL implementations in DB2, MS SQL, […]