ALTER Procedure dbo.UPdata

(

@e_Nplan char(20),

@e_Ncas char(20)

)

As

DECLARE @Nplan as char(20)

DECLARE @Ncas as float(2)

SET @Nplan = @e_Nplan

SET @Ncas = CONVERT(float(2) , @e_Ncas)

Update Cis_OP_NO SET N_Cas100ks = @Ncas where N_Kplan =@Nplan

return