CREATE PROCEDURE [dbo].[People_Update](
@id int=0,
@FirstName nvarchar (50),
@LastName nvarchar(50),
@EmailAddress nvarchar(100),
@PhoneNumber varchar(20))
AS
IF EXISTS(SELECT id from People where id =@id)
BEGIN
UPDATE People
SET
FirstName=@FirstName,
LastName=@LastName,
EmailAddress=@EmailAddress,
PhoneNumber=@PhoneNumber

END
ELSE
BEGIN
INSERT INTO People([FirstName],[LastName],[EmailAddress],[PhoneNumber])
VALUES (@FirstName,@LastName,@EmailAddress,@PhoneNumber)
EN