T-SQL Code for popular 2048 Game

This GitHub repository contains code samples that demonstrate how to create and use the procedures for 2048 Game using SQL Server Transact SQL (T-SQL) in your favorite editor.

What is 2048 game?

This is the classical puzzle game, that is easy and fun to play. The objective of the game is to move the numbers (tiles in the matrix/board) in a way to combine them to create a tile with the number 2048.

SQL Procedures

Game consists of several procedures that make the game work. In order for the game to start, you will need to run all the procedures and use the main 'Play_game' procedure.

Two groups of procedure are available to start and play the game:

1. Procedures to create and initialize matrix (helper procedures)
2. Procedures to make moves (helper procedures)
3. Procedure to play the game (main procedure)

Create and initialize matrix

The SQL file: 01_Create_initialize.sql describes two procedures that create an empty matrix (board) for a given dimension and initialize the matrix by adding two start numbers at a random position [x,y].

Run the code:

-- Create board of size 4
EXEC dbo.CREATE_matrix 4

-- Initialize board of size 4 with two random numbers
EXEC dbo.FIND_ADD_number 4;
GO 2 

Procedures to make moves

The SQL file: 02_Move_procedures.sql describes four procedures that imitate a LEFT, RIGHT, UP and DOWN user move and calculates and moves the numbers in board accordingly.

Run the code:

-- Make a move UP on a board of size 4x4
EXEC dbo.MAKE_up  4

-- Make a move LEFT on a board of size 4x4
EXEC dbo.MAKE_left  4

Playing the game

The last file 03_Play_game.sql holds the procedure that will give you the ability to play the game. You can simply execute the procedure to do the moves, accordingly.

-- make a LEFT move
EXEC dbo.PLAY_game 'L', 4

-- make a UP move
EXEC dbo.PLAY_game 'U', 4

Generic code:

EXEC dbo.PLAY_game {direction}, {size}

For the {direction} use the following abbreviations:

1. 'D' to move DOWN
2. 'U' to move UP
3. 'L' to move LEFT
4. 'R' to move RIGHT

And for the size it can be any give integer that is between 3 or above.

Start The game

If you want to play 4x4 board, you will need to create a bord and add two numbers that will be placed at the random position. This can be done with:

EXEC  [dbo].[CREATE_matrix] 4;
GO
EXEC [dbo].[FIND_ADD_number] 4;
GO 2

Creating an empty table in first procedure and adding two numbers in second procedure.

And now you can start playing by calling the move procedures. In this case, player is taking first move to go UP.

EXEC [dbo].[PLAY_game] 'U', 4

The UP move summed the two 2 numbers into 4 and added a new number 2 on blank tile (blank tile = 0).

Forking or cloning the repository

To work in GitHub, go to https://github.com/tomaztk/2048_sql_game and fork the repository. Work in your own fork and when you are ready to submit to make a change or publish your sample for the first time, submit a pull request into the master branch of this repository.

You can also clone the repository. Note: further changes should be fetched manually.

git clone -n https://github.com/tomaztk/2048_sql_game

Code of Conduct

Collaboration on this code is welcome and so are any additional questions or comments.

License

Code is licensed under the MIT license.

ToDO

1. Prettify T-SQL code
2. Optimize function for vectorization of table (or even come up with new function / data type)
3. Implementing procedures in Power BI or SSRS :-)