SQL Battleship

Question

Post reply

SQL Battleship

Sean Smith

SSCertifiable

Points: 5977
More actions
May 11, 2014 at 7:43 am

#285485

Comments posted to this topic are about the item SQL Battleship

Viewing 15 posts - 1 through 15 (of 74 total)

You must be logged in to reply to this topic. Login to reply

mariodelguidice Grasshopper Points: 21 More actions · Answer 1

This is an interesting program and quite original in thinking. I like it

Sean Smith SSCertifiable Points: 5977 More actions · Answer 2

Sean Smith

SSCertifiable

Points: 5977

May 17, 2014 at 6:48 am

#1714399

Why thank you! Hope you enjoyed it. 🙂

VictorSQL SSC Journeyman Points: 76 More actions · Answer 3

This is excellent! It's truly amazing to see other things which can be done with SQL other than standard SELECT/UPDATE/DELETE queries against a database.

Sean Smith SSCertifiable Points: 5977 More actions · Answer 4

Thank you! And I agree, which was part of the inspiration for this bit of code. 🙂 Hope you enjoyed it.

below86 SSChampion Points: 11532 More actions · Answer 5

Game over. Human player wins in 35 shots!:-)

-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.

below86 SSChampion Points: 11532 More actions · Answer 6

Nice work, I had to make a few modifications for it to work for me.

-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.

below86 SSChampion Points: 11532 More actions · Answer 7

Doing the declare and set of the variables in one statement gets an error for me.

-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.

below86 SSChampion Points: 11532 More actions · Answer 8

Sorry for multiple post, keep getting error trying to post the whole thing.

-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.

below86 SSChampion Points: 11532 More actions · Answer 9

Also had to change the VALUES statements.

-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.

Sean Smith SSCertifiable Points: 5977 More actions · Answer 10

Sean Smith

SSCertifiable

Points: 5977

May 27, 2014 at 10:22 am

#1716756

Which version of SQL Server are you running? 2005?

below86 SSChampion Points: 11532 More actions · Answer 11

Sean Smith-776614 (5/27/2014)
Which version of SQL Server are you running? 2005?

Yes, Our DEV server is still 2005, didn't want to run it on the prod server. 🙂

-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.

Sean Smith SSCertifiable Points: 5977 More actions · Answer 12

Ah, same here. 🙂 I have 2008 R2 locally so I just run it off my machine. 🙂

below86 SSChampion Points: 11532 More actions · Answer 13

Sean Smith-776614 (5/27/2014)
Ah, same here. 🙂 I have 2008 R2 locally so I just run it off my machine. 🙂

I don't have anything loaded to my machine.

-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.

Sean Smith SSCertifiable Points: 5977 More actions · Answer 14

below86 (5/27/2014)
Sean Smith-776614 (5/27/2014)
Ah, same here. 🙂 I have 2008 R2 locally so I just run it off my machine. 🙂
I don't have anything loaded to my machine.

Gotcha. Good score BTW. How do you find the computer AI?