CREATE PROCEDURE PLAY_THE_GAME_OF_THRONES
@player VARCHAR(50)
AS
DECLARE @random FLOAT; /* Probability of dying */
DECLARE @destiny VARCHAR(3);
BEGIN
SET @random = (SELECT RAND()*100 Game_of_Thrones)
IF(@random > 60)
BEGIN
SET @destiny = 'WIN'
END
ELSE
BEGIN
SET @destiny = 'DIE'
DELETE FROM CHARACTERS WHERE CHARACTERS.Name = @player OR CHARACTERS.Name = 'Sean Bean'
END
PRINT @destiny
END
@player VARCHAR(50)
AS
DECLARE @random FLOAT; /* Probability of dying */
DECLARE @destiny VARCHAR(3);
BEGIN
SET @random = (SELECT RAND()*100 Game_of_Thrones)
IF(@random > 60)
BEGIN
SET @destiny = 'WIN'
END
ELSE
BEGIN
SET @destiny = 'DIE'
DELETE FROM CHARACTERS WHERE CHARACTERS.Name = @player OR CHARACTERS.Name = 'Sean Bean'
END
PRINT @destiny
END