set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO


ALTER Procedure  [dbo].[AddNewInvestor](@FirstName varchar(40),@MiddleInitial varchar(40),@LastName varchar(40),@PhoneNumber varchar(20),@Province 
varchar(20), @City varchar(100), @Street varchar(40),@PostalCode varchar(20), @DateOfBirth DateTime,@CellNumber varchar(20),@WorkNumber varchar(20))
As
Declare @InvestorID int
select @InvestorID = LastValue from Keygen
insert into 
Investors(InvestorId,FirstName,MiddleInitial,LastName,PhoneNumber,Province,City,Street,PostalCode,DateOfBirth,CellNumber,WorkNumber)
values(@InvestorID,@FirstName,@MiddleInitial,@LastName,@PhoneNumber,@Province,@City,@Street,@PostalCode,@DateOfBirth,@CellNumber,@WorkNumber)
Return @@Error