1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
10. 10
11. 11
12. 12
13. 13
14. 14
15. 15
16. 16
17. 17
18. 18
19. 19
20. 20
21. 21
22. 22
23. 23
24. 24

BEGIN
    DECLARE @id_user int;
    IF (EXISTS(SELECT ut.id_user FROM project_userTable ut WHERE ut.userStr=@UserName OR ut.email = @email))
        begin
            SET @errors='Такое имя или пароль уже существуют';
            RETURN;
        end
    INSERT INTO project_userTable (userStr,passwordStr,email,profileLink,id_user_type,activate_ticket)
    VALUES (@UserName,@password, @email, @profileLink,2,@activate_ticket)
    IF (@@ROWCOUNT!=1)
    begin
        SET @errors='Ошибка регистрации';
        RETURN
    end
    SET @id_user=@@IDENTITY;
    INSERT INTO project_keyTable ([datetime],id_user, first_key ,second_key )
    VALUES (GETDATE(),@id_user,@firstKey,@secodKey)
    IF (@@ROWCOUNT=1)
    begin
        SET @errors='Done';
        RETURN
    end
    SET @errors='А воттеперь реально косяк.';
END