proba

CREATE procedure [dbo].[add_new_person] 
(
	-- Input Parametars
	@embg varchar(20),
	@first_name nvarchar(30),
	@last_name nvarchar(50),
	@username nvarchar(30),
	@password nvarchar(30),
	@address nvarchar(50) = NULL,
	@city nvarchar(30) = NULL,   
	@birth_date datetime = NULL,
	@birth_place nvarchar(30) = NULL
) AS
begin
 
	IF NOT EXISTS (SELECT 1 FROM person WHERE embg = @embg)
		INSERT INTO person
		(embg, first_name, last_name, username, password, address, city, birth_date, birth_place)
		VALUES
		(@embg, @first_name, @last_name, @username, @password, @address, @city, @birth_date, @birth_place)
	else
		UPDATE person
		SET first_name   = @first_name,
			last_name    = @last_name,
			username     = @username,
			password     = @password,
			address      = @address,
			city	     = @city,
			birth_date   = @birth_date,
			@birth_place = @birth_place
		WHERE embg = @embg	
 
end
go