SQL Server notes
Nested Cursors in T-SQL
We have two sample tables : tracks – which store audio track info matches – table which stores tracks matched in external data As you […]
MS SQL Server
Install SQL Server 2008 Express
SQL 2008 Express is available free from Microsoft. This article will take you through the process of how to install and configure SQL Server 2008 […]
View Table Constraints in SQL Server
To view all the constraints set for a table in MS SQL Server use the built in stored proc: sp_helpconstraint ‘tablename’
Get List of Last Changed Stored Procs in SQL Server
Sometimes when you have created/updated several stored procs in your database in SQL Server and you only need to transfer the changed ones to another […]