Tuesday, May 16, 2006

2727.aspx

Solving Sudoku puzzles with T-SQL

Now this is a creative use of Microsoft SQL Server stored procedures: solving Sudoku puzzles:



To make it even more fun for myself, I embarked on an exercise to write a program that solves Sudoku puzzles. And to make it even more challenging I decided not to write the program in the popular object-oriented fashion (Java, C++, C#, etc.) or in any of the old-fashioned procedural programming languages (Pascal, C, Basic etc); but in Transact SQL, within SQL Server 2000. Basically, I wanted to see how the features of T-SQL can be used to develop something like a Sudoku puzzle solution. I have learnt some useful things from the exercise, which I’m eager to pass on to my fellow programmers.


SQL Server 2005 makes even simpler as it is possible to write stored procedures with .NET


Thanks for the tip Marco

1 comment:

  1. Hello, I'm from the United States, and my name is Jelly John. As an experienced designer specialising in bikers jacket, I create classic, functional designs by combining classic design with modern trends. Having spent many years designing clothes, I place a strong emphasis on exquisite details and originality. In my design, the forceful, confident attitude of the biker's jacket is embraced while maintaining a sleek, modern look.

    ReplyDelete