‘T-SQL’ Articles

Select From One Table For Data That Doesn’t Exist In Another Table

Five different ways to query data from one table for data that doesn’t exist in another table.

How To Select Rows From Table Based On Time Value in DateTime Column

T-SQL code snippet for selecting rows from a database table based on time values in the datetime field.

Get Row Counts, Column Counts, Data Sizes For All Tables

T-SQL Script to get the row counts, column counts and data sizes for all the tables in a database.

Get The Number Of Days In The Current Month

T-SQL (SQL Server) code snippet to get the number of days in the current month.