Problem with syntax when trying to insert data through stored procedure into my table

[AmrGhoneem]

My Code as below:

ID,CustomerName,Customernumber,Type,Model,Serialnumber,PhoneNumber,Email,Country,SOW,Qty,InstallationDate,WarrantyExpiryDate,StopdateinCalculation,productDescription,GrossMaintenanceprice,YearMonth,ServiceTierlevel,SLAlevel,Location,NrofDaysincontract,TotalGrossMaintenanceamount,Yearamount,Netamountperperiod)


	@ID int,
	@CustomerName nvarchar(255),
	@Customernumber int,
	@Type nvarchar(255),
	@Model nvarchar(255),
	@Serialnumber nvarchar(255),
	@PhoneNumber nvarchar(255),
	@Email nvarchar(255),
	@Country nvarchar(255),
	@SOW nvarchar(255),
	@Qty int,
	@InstallationDate datetime,
	@WarrantyExpiryDate datetime,
	@StartdateinCalculation datetime,
	@StopdateinCalculation nvarchar(255),
	@ProductDescription nvarchar(255),
	@GrossMaintenanceprice money,
	@YearMonth nvarchar(255),
	@ServiceTierlevel nvarchar(255),
	@SLALevel nvarchar(255),
	@Location nvarchar(255),
	@Nrofdaysincontract int,
	@totalGrossMaintenanceamount money,
	@Yearamount money,
	@Netamountperperiod money,

 AS
  
	INSERT INTO Contracts (ID,CustomerName,Customernumber,Type,Model,Serialnumber,PhoneNumber,Email,Country,SOW,Qty,InstallationDate,WarrantyExpiryDate,StopdateinCalculation,ProductDescription,GrossMaintenanceprice,YearMonth,ServiceTierlevel,SLAlevel,Location,NrofDaysincontract,TotalGrossMaintenanceamount,Yearamount,Netamountperperiod)
 	   Values(@ID,@CustomerName,@Customernumber,@Type,@Model,@Serialnumber,@PhoneNumber,@Email,@Country,@SOW,@Qty,@InstallationDate,@WarrantyExpiryDate,@StopdateinCalculation,@ProductDescription,@GrossMaintenanceprice,@YearMonth,@ServiceTierlevel,@SLAlevel,@Location,@NrofDaysincontract,@TotalGrossMaintenanceamount,@Yearamount,@Netamountperperiod)
	
	RETURN

i cant find my syntax error 3 days searching any help will be appricated.

Thanx

Amr Ghoneem

[Luuk]

maybe you should not put a comma here:
@Netamountperpe riod money,

[prigupta2]

CREATE PROCEDURE [dbo].[spContracts]    
    @ID int = Null,
    @CustomerName nvarchar(255) = Null,
    @Customernumber int = Null,
    @Type nvarchar(255) = Null,
    @Model nvarchar(255) = Null,
    @Serialnumber nvarchar(255) = Null,
    @PhoneNumber nvarchar(255) = Null,
    @Email nvarchar(255) = Null,
    @Country nvarchar(255) = Null,
    @SOW nvarchar(255) = Null,
    @Qty int = Null,
    @InstallationDate datetime = Null,
    @WarrantyExpiryDate datetime = Null,
    @StartdateinCalculation datetime = Null,
    @StopdateinCalculation nvarchar(255) = Null,
    @ProductDescription nvarchar(255) = Null,
    @GrossMaintenanceprice money = Null,
    @YearMonth nvarchar(255) = Null,
    @ServiceTierlevel nvarchar(255) = Null,
    @SLALevel nvarchar(255) = Null,
    @Location nvarchar(255) = Null,
    @Nrofdaysincontract int = Null,
    @totalGrossMaintenanceamount money = Null,
    @Yearamount money = Null,
    @Netamountperperiod money = Null
 
 AS
 
BEGIN 
 
    INSERT INTO Contracts (ID,CustomerName,Customernumber,Type,Model,Serialnumber,PhoneNumber,Email,Country,SOW,Qty,InstallationDate,WarrantyExpiryDate,StopdateinCalculation,ProductDescription,GrossMaintenanceprice,YearMonth,ServiceTierlevel,SLAlevel,Location,NrofDaysincontract,TotalGrossMaintenanceamount,Yearamount,Netamountperperiod)
			Values(@ID,@CustomerName,@Customernumber,@Type,@Model,@Serialnumber,@PhoneNumber,@Email,@Country,@SOW,@Qty,@InstallationDate,@WarrantyExpiryDate,@StopdateinCalculation,@ProductDescription,@GrossMaintenanceprice,@YearMonth,@ServiceTierlevel,@SLAlevel,@Location,@NrofDaysincontract,@TotalGrossMaintenanceamount,@Yearamount,@Netamountperperiod)
 
END

EXECUTE [spContracts] @id =1, @Customername = 'Your Name'