IF NOT EXISTS (SELECT * FROM sys.objects WHERE name = 'SetEntityCode' AND TYPE IN (N'P', N'PC'))
EXEC(N'CREATE PROCEDURE SetEntityCode @TenantId uniqueidentifier, @EntityName varchar(60) AS
    BEGIN
        SET NOCOUNT ON

        DECLARE @Code INT

        SET @Code = (SEKECT Code FROM EntityCode WHERE TENANTID = @TenantId and EntityName = @EntityName)

        IF @Code > 0
            BEGIN
                UPDATE EntityCode SET Code = (Code + 1) WHERE TENANTID  = @TenantId  AND EntityName = @EntityName
                SET @Code = @Code + 1
            END
        ELSE
            BEGIN
                INSERT EntityCode (ENTITYNAME, TENANTID, CODE) VALUES (@EntityName, @TenantId, 1)
                SET @Code = 1
            END

        RETURN @Code
    END')