SQL Game

[swint002]

Here's a checkers game written in T-SQL that you can play in the sql
query analyzer.
http://www.geocities.com/swint002/checkers.txt

Enjoy :-)

[Ross Presser]

On 4 Jul 2004 09:34:47 -0700, sw******@yahoo.com wrote:

Here's a checkers game written in T-SQL that you can play in the sql
query analyzer.
http://www.geocities.com/swint002/checkers.txt

Enjoy :-)

Now that's SQL abuse. :)

I remember about 2 years ago, there was discussion in
rec.games.roguelike.misc about the possibility of doing a roguelike game in
SQL.

[Philip Yale]

Ross Presser <rp******@imtek.com> wrote in message news:<14******************************@40tude.net> ...

On 4 Jul 2004 09:34:47 -0700, sw******@yahoo.com wrote:

Here's a checkers game written in T-SQL that you can play in the sql
query analyzer.
http://www.geocities.com/swint002/checkers.txt

Enjoy :-)

Now that's SQL abuse. :)

I remember about 2 years ago, there was discussion in
rec.games.roguelike.misc about the possibility of doing a roguelike game in
SQL.

BTW - there's a bug in the game. If you promote a piece to a King,
then try to 'take' a piece backwards in a move that would result in a
double-take, you get a "stored procedure not found" error. Shame
really, because it's a very neat game. If I understood the code well
enough I might even try to debug it, but I ain't that clever and I
don't have the time! :-)

[--CELKO--]

>> Here's a checkers game written in T-SQL <<

Part of me is delighted with this because I love weird programming
tricks. Another part of me is thinking "I hope he gets a job soon" :)

Instead of using T-SQL for this, try to use more pure SQL in a game.
The following is a damn good exercise.

I happen to like Pai Gow Tiles for two reasons: (1) it is cool to be
the only white guy looking a like James Bond in a three piece suit at
an Asian game table (2) The traditional house way is statistical
flawed.

You have a set of 32 Chinese dominoes. These dominoes are based on the
toss of two dice seen as a total and not as a pair, so there are no
blanks like western dominoes and there are duplicates in the set.

The players get a hand of four tiles, which they arrange into two
hands (high and low) of two tiles. For you to win, both your hands
must beat the bank;
For the banker to win, both his hands must beat both your hands;
otherwise, the bet is a push (tie).

There are three ways to arrange the four tiles of a hand; the banker's
hand has to be drawn from the remainging tiles. Basically, it is a
combinatorics and probability problem.

The real trick is to do the data mining to come up with rules for
playing the game.

Google it!