Database

Create PROCEDURE dbo.SprocInsertUpdatePerson
(
	@code int,
	@id int,
	@name nvarchar(50),
	@passportNumber nvarchar(50),
	@nationality nvarchar(50),
	@created datetime,
	@creator nvarchar(50)	
)
AS

	Declare @ReturnValue int
	if (@Code IS NULL) --New Item
	Begin
		insert into Person
		(
			Code,
			Id,
			Name,
			PassportNumber,
			Nationality,
			Created,
			Creator
		)	
		values
		(
			@code,
			@id,
			@name,
			@passportNumber,
			@nationality,
			@created,
			@creator
		)
		
		Select @ReturnValue = Scope_Identity()
		
	End
	
	
	else
	
	Begin --Update Item
		Update Person  		
		Set Code = @code,
		Id = @id,
		Name = @name,
		PassportNumber = @passportNumber,
		Nationality = @nationality,
		Created = @created,
		Creator = @creator				
		where Id = @id
		
		Select @ReturnValue = @Id
	End
	
	
	IF (@@ERROR != 0)
	BEGIN
		RETURN -1
	END
	ELSE
	BEGIN
		RETURN @ReturnValue
	END

if (exists(SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' AND TABLE_NAME = 'TEMP1'))
    begin
    Drop TABLE .dbo.TEMP1
end