Listing 2: Creating and Populating the SudokuInputD Table

IF OBJECT_ID('SudokuInputD') IS NOT NULL
  DROP TABLE SudokuInputD;
GO
CREATE TABLE SudokuInputD
(
  row INT NOT NULL PRIMARY KEY,
  [1] INT NULL,
  [2] INT NULL,
  [3] INT NULL,
  [4] INT NULL,
  [5] INT NULL,
  [6] INT NULL,
  [7] INT NULL,
  [8] INT NULL,
  [9] INT NULL
);
INSERT INTO SudokuInputD 
  VALUES( 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,    1);
INSERT INTO SudokuInputD
  VALUES( 2, NULL,    2, NULL, NULL, NULL,    3,    9, NULL, NULL);
INSERT INTO SudokuInputD
  VALUES( 3, NULL, NULL, NULL,    9,    1,    4, NULL, NULL,    5);
INSERT INTO SudokuInputD
  VALUES( 4,    9,    8, NULL,    5, NULL, NULL,    1, NULL, NULL);
INSERT INTO SudokuInputD
  VALUES( 5, NULL, NULL, NULL,    6, NULL,    8, NULL, NULL, NULL);
INSERT INTO SudokuInputD
  VALUES( 6, NULL, NULL,    6, NULL, NULL,    7, NULL,    8,    3);
INSERT INTO SudokuInputD
  VALUES( 7,    4, NULL, NULL,    3,    7,    9, NULL, NULL, NULL);
INSERT INTO SudokuInputD
  VALUES( 8, NULL, NULL,    5,    2, NULL, NULL, NULL,    7, NULL);
INSERT INTO SudokuInputD
  VALUES( 9,    2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);