请问各位高手:
触发器与存储过程的格式是怎样的呀?请指点一下吧,谢谢了.
參考答案:给你举例说明吧：
触发器：
有两个表A和B，A和B中都有name字段。在A的字段进行改变时，B中的字段也同步改变：
creat trigger trigger_name on A
for update
as
declare @ls_name varchar(20)
if update(name)
begin
select @ls_name = name from inserted
update B set name = @ls_name
end
存储过程：
MC是商品名称，DJ是商品单价，BH是商品销售单的编号，RQ是销售单的开出时间。该过程是求出平均单价并返回。
DECREATE PROCEDURE dbo.SP_H_TJ
@KSSJ DATETIME,
@JSSJ DATETIME
AS
SELECT MC AS MC, (SUM(DJ)/COUNT(BH)) AS PJJG
INTO #SPQK
FROM SPXS
WHERE RQ BETWEEN @KSSJ AND @JSSJ
SELECT *
FROM #SPQK
