SQL Server - stored procedure que me actualice la tabla con los valores que introduzco en el formulario

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

-- =============================================

-- Author:		ben sing

-- Create date: 26/08/2018

-- Description:

-- =============================================

CREATE PROCEDURE [dbo].[simpledt] (@nomb varchar(50), @num bigint, @mont1 datetime,  @tim datetime,  @reserv nvarchar(8), @pax int,  @nationality nvarchar(50),  @room int,  @class nvarchar(10), @datein datetime,  @dateout datetime,  @days int,  @price money,  @subtotala money, @discount int,  @amount money, @subtotalb money,  @tax int,  @taxamt money,  @laundry money, @telephone money,  @stotal money, @taxn int,  @taxm money,  @totalc money,  @exchnge int,  @total nvarchar(50),  @creditcard nvarchar(50), @remarks nvarchar(50),  @emnombr nvarchar(50),  @cobrado char(10), @cobrada nvarchar(50))

as

begin

set nocount on

    insert into dbo.tblfact (nomb, num, mont1, tim, reserv, pax,  nationality, room, class, datein,  dateout, days, price, subtotala, discount,  amount,  subtotalb, tax, taxamt, laundry, telephone, stotal, taxn, taxm, totalc,  exchnge,  total,  creditcard, remarks, emnombr,  cobrado, cobrada)

values

(@nomb = 'cat',

 @num = 50611,

 @mont1 = 201806,

 @tim  = 2018,

 @reserv = '2611-15',

 @pax = 2,

 @nationality = 'cost',

 @room = 14,

 @class = stddbl,

 @datein = 20180623,

 @dateout = 20180624,

 @days = 1,

 @price = 70,

 @subtotala = 70,

 @discount = 10,

 @amount = 7,

 @subtotalb = 63,

 @tax = '10',

 @taxamt = 6,

 @laundry = 0,

 @telephone = 0,

 @stotal = 69,

 @taxn = '13',

 @taxm = 10,

 @totalc = 73,

 @exchnge = 560,

 @total = 100,

 @creditcard = '44444',

 @remarks = 'xxxx',

 @emnombr = 'steve',

 @cobrado = '0',

 @cobrada = '1')

END

CREATE PROCEDURE [dbo].[updmnt] (@mydate datetime, @num bigint, @mont1 datetime)

as

begin

set nocount on

    set @mydate = GETDATE();

    set @mydate = (@mydate, yyyymm)

UPDATE tblfact

set mont1 = @mydate

where num = @num

END

declare @mydate datetime,@resul varchar(6)=''

set @mydate=GETDATE()

set @resul=cast(DATEPART(YYyy,@mydate) as varchar(4)) + cast(DATEPART(MM,@mydate) as varchar(2))

select @resul