SQL Server Articles

Database Compare using FREEWARE Tools!

Author: David Wiseman (Administrator), | Date: 2008-06-25 | Source: www.wisesoft.co.uk

Rating: {Not Rated}

My Rating: {log in to vote!}

This article explains how to compare two database schema's, highlighting any objects that are different and reporting changes in those objects. This is quite a common requirement, as people often want to compare development databases with their production database. Also, you might just want to compare two versions of a stored procedure, highlighting any differences between the two. Unfortunately, SQL Server does not include any tools for comparing database schema's. There are some commercial

Kill Users Stored Procedure

Author: David Wiseman (Administrator), | Date: 2007-12-23 | Source: www.wisesoft.co.uk

Rating: {Not Rated}

My Rating: {log in to vote!}

T-SQL procedure to forcibly disconnect users from a database.

Proper Case T-SQL User Defined Function

Author: David Wiseman (Administrator), | Date: 2007-12-23 | Source: www.wisesoft.co.uk

Rating: {Not Rated}

My Rating: {log in to vote!}

A T-SQL function to convert text into ProperCase.

T-SQL Age Calculation Function

Author: David Wiseman (Administrator), | Date: 2007-09-30 | Source: www.wisesoft.co.uk

Rating: {Not Rated}

My Rating: {log in to vote!}

T-SQL Function to calculate a persons age.