Five different ways to query data from one table for data that doesn’t exist in another table.
06 January 2009 by Shiva
Five different ways to query data from one table for data that doesn’t exist in another table.
22 December 2008 by Shiva
T-SQL code snippet for selecting rows from a database table based on time values in the datetime field.
20 September 2008 by Shiva
T-SQL Script to get the row counts, column counts and data sizes for all the tables in a database.
15 September 2008 by Shiva
T-SQL (SQL Server) code snippet to get the number of days in the current month.