Nov 12, 2009

Solving Sudoku using SQL Server 2005 - Step by Step - Part #3

›
Implementation of RunSolveAlgorithm1: In the previous post  of this series , we created the procedure stub for each algorithm. This post w...
Nov 10, 2009

Solving Sudoku using SQL Server 2005 - Step by Step - Part #2

›
In the first part of this series, we created the base objects needed to work on our solution. Now, there are two parts to building the solu...
Nov 9, 2009

Solving Sudoku using SQL Server 2005 - Step by Step - Part #1

›
This one is going to be a series. I thought I was going to come up with a single query to solve Sudoku (without choosing the brute force met...
2 comments:

Object Oriented SQL Programming with SQL Server 2005

›
In this post, I have attempted a crude implementation of Object Oriented SQL Programming using the APPLY operator in SQL Server 2005. I feel...
Nov 6, 2009

A Scenario to Ponder #15

›
I guess, by now, most of you are familiar with the SQL Server 2005 sample database - AdventureWorks . We will use one of the tables from thi...
1 comment:
Oct 28, 2009

Understanding Transaction Isolation Levels in SQL Server

›
One of the most important concepts pertaining to any DBMS that every database programmer must know is the Transaction Isolation Levels . Som...
Oct 23, 2009

Custom Sorting and Paging in SQL Server Stored Procedure

›
This post is about achieving pagination using stored procedure, without using dynamic SQL. The solution presented should work for both SQL S...