A simple user defined function that returns the number of days in month for any date, with the leap year rule for February built in.
SQL SERVER – Correlated and Noncorrelated – SubQuery Introduction, Explanation and Example
What is the difference between correlated and noncorrelated subqueries? I explain both kinds with simple AdventureWorks examples.
SQL SERVER – 2005 – Introduction and Explanation to sqlcmd
An introduction to sqlcmd, the SQL Server 2005 command prompt utility that runs ad hoc T-SQL statements and scripts, and how it improves on isql and osql.
SQLAuthority News – Interesting Read – Using A SQL JOIN In A SQL UPDATE/Delete Statement – Ben Nadel
Ben Nadel, my favorite ColdFusion blogger, wrote two clear articles on using a SQL JOIN in UPDATE and DELETE statements. Both are worth a read.
SQL SERVER – 2005 – Find Tables With Primary Key Constraint in Database
A script to find tables with primary key constraint in a SQL Server 2005 database, listing the index name, table name and column name from sys.indexes.
SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database
Keys are critical to any database. This script finds every table with a foreign key constraint in SQL Server 2005, with its column and the referenced table.
SQL SERVER – 2005 – Search Stored Procedure Code – Search Stored Procedure Text
How to search stored procedure code in SQL Server 2005 for a table or column name, using sys.procedures and OBJECT_DEFINITION instead of sp_depends.