使用存储过程及触发器案例

一：使用存储过程：

ALTER PROCEDURE [dbo].[procaddchanp] 
@prd_id int,
@prd_title varchar(50),
@prd_modle varchar(50),
@prd_texing varchar(50),
@prd_more varchar(50),
@prd_img varchar(50)
AS
BEGIN
insert into Products (prd_id,prd_title,prd_modle,prd_texing,prd_more,prd_img) values(@prd_id,@prd_title,@prd_modle,@prd_texing,@prd_more,@prd_img)
END

 

二：使用触发器：

 

-- Create date: ２０１０－９－２５　２２：１８
-- Description:    删除产品列别
-- =============================================
ALTER TRIGGER [dbo].[trideltprdclas]
   ON  [dbo].[Prd_class] 
   instead of DELETE
AS 
BEGIN
declare @id int
select @id=prd_id from deleted
delete Products where prd_id=@id
delete Prd_class where prd_id=@id
END