create or alter procedure sp_StokKartiDegistir 
@Kodu nvarchar(30), 
@UreticiFirmaKodu nvarchar(30), 
@StokAdi nvarchar(40), 
@Barkodu nvarchar(16), 
@AlisKdv smallint, 
@SatisKdv smallint, 
@F1Fiyat float, 
@F2Fiyat float, 
@F3Fiyat float, 
@F4Fiyat float,
@F1Kdv nvarchar(1), 
@F2Kdv nvarchar(1),
@F3Kdv nvarchar(1),
@F4Kdv nvarchar(1), 
@GrupAdi nvarchar(30),
@KULNO int,
@KULADI nvarchar(20)
as
update STOKKARTI set UreticiFirmaKodu = UreticiFirmaKodu, 
  StokAdi=@StokAdi, Barkodu = @Barkodu, AlisKdv=@AlisKdv, 
  SatisKdv=@SatisKdv, F1Fiyat=@F1Fiyat, F2Fiyat=@F2Fiyat, F3Fiyat=@F3Fiyat, F4Fiyat=@F4Fiyat,
  F1Kdv=@F1Kdv, F2Kdv=@F2Kdv,F3Kdv=@F3Kdv,F4Kdv=@F4Kdv, GrupAdi=@GrupAdi,KULNO=@KULNO,KULADI=@KULADI
  where Kodu = @Kodu
