You are only limited by your imagination
February 6, 2012 by m0gb0y74 | 0 comments
To determine what SQL Server version and edition that you are running execute the following Sql: SELECT @@VERSION This will return a message similar to the following supplying all the details that you require: Microsoft SQL Server 2005 – 9.00.5057.00 … Continue reading
June 30, 2011 by m0gb0y74 | 0 comments
I have really been getting into automated unit-testing and Test Driven Development (TDD) over the last year. Like many developers I work with database tables that have a surrogate primary key. In the case of Microsoft SQL Server this handled through … Continue reading
November 15, 2010 by m0gb0y74 | 0 comments
There are numerous post on forums and blogs that aim to address the problem of determining the number of working days between two dates in SQL Server. Unfortunately, not all of them work. I managed to find a great post … Continue reading