存储过程实例002--添加一条记录

接上篇，创建存储过程：往book表里添加一条记录

Create proc insert_book
@param1 char(10),@param2 varchar(20),@param3 money,@param4 money output
with encryption ---------加密
as
insert book (编号,书名,价格) Values (@param1,@param2,@param3)
select @param4=sum(价格) from book
go 

执行此存储过程：

declare @total_price money
exec insert_book '003','Delphi 控件开发指南',$100,@total_price
print '总金额为'+convert(varchar,@total_price)
go