使用下面显示的触发器将产品的price更新为返点。但我希望在以后的插入中,不能更新已应用折扣的记录。
我还能添加什么?
create Trigger tri on t1
after insert As
UPDATE t1
SET price = CASE
WHEN column1 = 'Rebate' THEN price * 0.5
ELSE price
END
ALTER PROCEDURE INSERT_PDF
@DOCUMENT VARBINARY(MAX) = NULL
AS
BEGIN
INSERT INTO PDF
(Document)
VALUES
(@DOCUMENT)
END
GO
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using System