AddStudent2Dynamic

ALTER PROCEDURE AddStudent2Dynamic (@p_fname VARCHAR(30), @p_lname VARCHAR(50), @p_tallness INT)
AS
DECLARE
    @v_login VARCHAR(6), @v_email VARCHAR(50), @v_counter INT;
    SET @v_counter = 0;
    SET @v_login = LOWER(SUBSTRING(@p_lname,1, 3)) + '0' + CAST(@v_counter AS CHAR);
WHILE dor0023.LoginExists(@v_login) <> 0
    BEGIN
        SET @v_counter = @v_counter + 1;
        IF @v_counter < 100
            SET @v_login = LOWER(SUBSTRING(@p_lname,1, 3)) + '0' + CAST(@v_counter AS CHAR);
        ELSE
            SET @v_login = LOWER(SUBSTRING(@p_lname,1, 3)) + CAST(@v_counter AS CHAR);
    END
SET @v_email = @v_login + '@vsb.cz';
INSERT INTO Student(login, fname, lname, email, tallness) VALUES(@v_login, @p_fname, @p_fname, @v_email, @p_tallness);