create procedure sp_StokFiyatDegistir
@Kodu nvarchar(30),
@F1Fiyat float,
@F2Fiyat float,
@F3Fiyat float,
@F4Fiyat float,
@F5Fiyat float,
@F6Fiyat float,
@F7Fiyat float,
@F8Fiyat float,
@F9Fiyat float,
@F10Fiyat float,
@F11Fiyat float,
@F12Fiyat float,
@F13Fiyat float,
@F14Fiyat float,
@F15Fiyat float,
@F16Fiyat float,
@F17Fiyat float,
@F18Fiyat float,
@F19Fiyat float,
@F20Fiyat float,
@F1Kdv nvarchar(1),
@F2Kdv nvarchar(1),
@F3Kdv nvarchar(1),
@F4Kdv nvarchar(1),
@F5Kdv nvarchar(1),
@F6Kdv nvarchar(1),
@F7Kdv nvarchar(1),
@F8Kdv nvarchar(1),
@F9Kdv nvarchar(1),
@F10Kdv nvarchar(1),
@F11Kdv nvarchar(1),
@F12Kdv nvarchar(1),
@F13Kdv nvarchar(1),
@F14Kdv nvarchar(1),
@F15Kdv nvarchar(1),
@F16Kdv nvarchar(1),
@F17Kdv nvarchar(1),
@F18Kdv nvarchar(1),
@F19Kdv nvarchar(1),
@F20Kdv nvarchar(1),
@KULNO int,
@KULADI nvarchar(20),
@F1DovizKodu nvarchar(2),
@F2DovizKodu nvarchar(2),
@F3DovizKodu nvarchar(2),
@F4DovizKodu nvarchar(2),
@F5DovizKodu nvarchar(2),
@F6DovizKodu nvarchar(2),
@F7DovizKodu nvarchar(2),
@F8DovizKodu nvarchar(2),
@F9DovizKodu nvarchar(2),
@F10DovizKodu nvarchar(2),
@F11DovizKodu nvarchar(2),
@F12DovizKodu nvarchar(2),
@F13DovizKodu nvarchar(2),
@F14DovizKodu nvarchar(2),
@F15DovizKodu nvarchar(2),
@F16DovizKodu nvarchar(2),
@F17DovizKodu nvarchar(2),
@F18DovizKodu nvarchar(2),
@F19DovizKodu nvarchar(2),
@F20DovizKodu nvarchar(2),
@F1FiyatH float,
@F2FiyatH float,
@F3FiyatH float,
@F4FiyatH float,
@F5FiyatH float,
@F6FiyatH float,
@F7FiyatH float,
@F8FiyatH float,
@F9FiyatH float,
@F10FiyatH float,
@F11FiyatH float,
@F12FiyatH float,
@F13FiyatH float,
@F14FiyatH float,
@F15FiyatH float,
@F16FiyatH float,
@F17FiyatH float,
@F18FiyatH float,
@F19FiyatH float,
@F20FiyatH float,
@SatisKdv float,
@Update_Date smalldatetime
as

update StokFiyat set
F1Fiyat =@F1Fiyat,
F2Fiyat =@F2Fiyat,
F3Fiyat =@F3Fiyat,
F4Fiyat =@F4Fiyat,
F5Fiyat =@F5Fiyat,
F6Fiyat =@F6Fiyat,
F7Fiyat =@F7Fiyat,
F8Fiyat =@F8Fiyat,
F9Fiyat =@F9Fiyat,
F10Fiyat =@F10Fiyat,
F11Fiyat =@F11Fiyat,
F12Fiyat =@F12Fiyat,
F13Fiyat =@F13Fiyat,
F14Fiyat =@F14Fiyat,
F15Fiyat =@F15Fiyat,
F16Fiyat =@F16Fiyat,
F17Fiyat =@F17Fiyat,
F18Fiyat =@F18Fiyat,
F19Fiyat =@F19Fiyat,
F20Fiyat =@F20Fiyat,
F1Kdv =@F1Kdv,
F2Kdv =@F2Kdv,
F3Kdv =@F3Kdv,
F4Kdv =@F4Kdv,
F5Kdv =@F5Kdv,
F6Kdv =@F6Kdv,
F7Kdv =@F7Kdv,
F8Kdv =@F8Kdv,
F9Kdv =@F9Kdv,
F10Kdv =@F10Kdv,
F11Kdv =@F11Kdv,
F12Kdv =@F12Kdv,
F13Kdv =@F13Kdv,
F14Kdv =@F14Kdv,
F15Kdv =@F15Kdv,
F16Kdv =@F16Kdv,
F17Kdv =@F17Kdv,
F18Kdv =@F18Kdv,
F19Kdv =@F19Kdv,
F20Kdv =@F20Kdv,
KULNO =@KULNO,
KULADI =@KULADI,
F1DovizKodu =@F1DovizKodu,
F2DovizKodu =@F2DovizKodu,
F3DovizKodu =@F3DovizKodu,
F4DovizKodu =@F4DovizKodu,
F5DovizKodu =@F5DovizKodu,
F6DovizKodu =@F6DovizKodu,
F7DovizKodu =@F7DovizKodu,
F8DovizKodu =@F8DovizKodu,
F9DovizKodu =@F9DovizKodu,
F10DovizKodu =@F10DovizKodu,
F11DovizKodu =@F11DovizKodu,
F12DovizKodu =@F12DovizKodu,
F13DovizKodu =@F13DovizKodu,
F14DovizKodu =@F14DovizKodu,
F15DovizKodu =@F15DovizKodu,
F16DovizKodu =@F16DovizKodu,
F17DovizKodu =@F17DovizKodu,
F18DovizKodu =@F18DovizKodu,
F19DovizKodu =@F19DovizKodu,
F20DovizKodu =@F20DovizKodu,
F1FiyatH =@F1FiyatH,
F2FiyatH =@F2FiyatH,
F3FiyatH =@F3FiyatH,
F4FiyatH =@F4FiyatH,
F5FiyatH =@F5FiyatH,
F6FiyatH =@F6FiyatH,
F7FiyatH =@F7FiyatH,
F8FiyatH =@F8FiyatH,
F9FiyatH =@F9FiyatH,
F10FiyatH =@F10FiyatH,
F11FiyatH =@F11FiyatH,
F12FiyatH =@F12FiyatH,
F13FiyatH =@F13FiyatH,
F14FiyatH =@F14FiyatH,
F15FiyatH =@F15FiyatH,
F16FiyatH =@F16FiyatH,
F17FiyatH =@F17FiyatH,
F18FiyatH =@F18FiyatH,
F19FiyatH =@F19FiyatH,
F20FiyatH =@F20FiyatH,
SatisKdv =@SatisKdv,
Update_Date =@Update_Date
where Kodu = @Kodu

