SQL Unit Test for FixZoneName

test FixZoneName.sql

ALTER PROCEDURE [UnitTests].[test FixZoneName]
AS
BEGIN
    --Assemble
    EXEC tSQLt.FakeTable @TableName = 'sth.GameZone';

    INSERT INTO sth.GameZone(Id, ZoneName)
    VALUES(1, 'Green Hill');

    --Act
    EXEC sth.FixZoneName @zoneId = 1;

    --Assert
    DECLARE @actualZoneName VARCHAR(50);
    SELECT @actualZoneName = ZoneName
    FROM sth.GameZone
    WHERE Id = 1;

    EXEC tSQLt.AssertEqualsString @Expected = 'Green Hill Zone',
                                  @Actual = @actualZoneName,
                                  @Message = 'Zone name was not fixed';

END;