CREATE PROCEDURE [dbo].[sp_UpdateOrInsertSiparisVerildi]
    @stockRef INT,
    @userId INT,
    @amount VARCHAR(50)
AS
BEGIN
        INSERT INTO STOK_RAPOR_SIPARISLER (STOCKREF, USERID, AMOUNT, TYPE_, ORDERDATE)
        VALUES (@stockRef, @userId, @amount, 1, CAST(GETDATE() AS DATE));
		INSERT INTO STOK_RAPOR_SIPARISLER_LOG (STOCKREF, USERID, AMOUNT, TYPE_)
        VALUES (@stockRef, @userId, @amount, 2);
END;