Create a Microsoft SQL Database table with 10,000 randomly generated numbers.

DROP DATABASE IF EXISTS [hello_world];
CREATE DATABASE [hello_world];
GO

USE [hello_world];
GO

DROP TABLE IF EXISTS [world];
CREATE TABLE  [world] (
  [id] INT IDENTITY (1, 1) NOT NULL,
  [randomNumber] INT NOT NULL DEFAULT 0,
  PRIMARY KEY  (id)
)
GO

DECLARE @cnt INT = 0;
DECLARE @max INT = 10000;

WHILE @cnt < @max
BEGIN
	INSERT INTO [world] ([randomNumber]) VALUES ( ABS(CHECKSUM(NewId())) % 10000 );
	SET @cnt = @cnt + 1;
END;
GO


DROP TABLE IF EXISTS [fortune];
CREATE TABLE  [fortune] (
  [id] INT IDENTITY (1, 1) NOT NULL,
  [message] NVARCHAR(2048) NOT NULL,
  PRIMARY KEY  (id)
)
GO

INSERT INTO [fortune] ([message]) VALUES ('fortune: No such file or directory');
INSERT INTO [fortune] ([message]) VALUES ('A computer scientist is someone who fixes things that aren''t broken.');
INSERT INTO [fortune] ([message]) VALUES ('After enough decimal places, nobody gives a damn.');
INSERT INTO [fortune] ([message]) VALUES ('A bad random number generator: 1, 1, 1, 1, 1, 4.33e+67, 1, 1, 1');
INSERT INTO [fortune] ([message]) VALUES ('A computer program does what you tell it to do, not what you want it to do.');
INSERT INTO [fortune] ([message]) VALUES ('Emacs is a nice operating system, but I prefer UNIX. — Tom Christaensen');
INSERT INTO [fortune] ([message]) VALUES ('Any program that runs right is obsolete.');
INSERT INTO [fortune] ([message]) VALUES ('A list is only as strong as its weakest link. — Donald Knuth');
INSERT INTO [fortune] ([message]) VALUES ('Feature: A bug with seniority.');
INSERT INTO [fortune] ([message]) VALUES ('Computers make very fast, very accurate mistakes.');
INSERT INTO [fortune] ([message]) VALUES ('<script>alert("This should not be displayed in a browser alert box.");</script>');
INSERT INTO [fortune] ([message]) VALUES ('フレームワークのベンチマーク');
GO