CREATE PROCEDURE AddRegLink @first_name nvarchar(255), @last_name nvarchar(255)
AS
	DECLARE @id int;
	@id = (SELECT id FROM dbo.Users WHERE user_login = @user_login and user_password = @user_password)
IF @id IS NOT NULL  
	BEGIN
		-- Логика связанная с полученным @id пользователя 
		RETURN 1;
	END
ELSE RETURN 0;

CREATE PROCEDURE MyProcedure @first_name nvarchar(255), @last_name nvarchar(255)
AS
	DECLARE @id int;
	@id = (SELECT id FROM dbo.Users WHERE first_name = @first_name and last_nam = @last_name)
IF @id IS NOT NULL  
	BEGIN
		-- Логика связанная с полученным @id пользователя 
		RETURN 1;
	END
ELSE RETURN 0;