/*
首先来看看mssql 存储过程创建
create procedure proc_stu
as
select * from student
go 创建一个过程：例子
下面的语句创建的架构中的人力资源程序remove_emp：
create procedure remove_emp (employee_id number) as
tot_em number;
begin
delete from employees
where employees.employee_id = remove_emp.employee_id;
tot_emps := tot_emps - 1;
end;
关于存储过程简单实例看了，那么我们来看语法
create { proc | procedure } [schema_name.] procedure_name [ ; number ]
[ { @parameter [ type_schema_name. ] data_type }
[ varying ] [ = default ] [ out | output ] [readonly]
] [ ,...n ]
[ with [ ,...n ] ]
[ for replication ]
as { [;][ ...n ] | }
[;]
::=
[ encryption ]
[ recompile ]
[ execute as clause ]
::=
{ [ begin ] statements [ end ] }
::=
external name assembly_name.class_name.method_name
好我们来看一个实例应用中的实例，
查询id为1的记录用存储过程实例
@total int output
-----------------------------------
set @sql=n'select a,b,c,d from t where id=1'
exec sp_executesql @sql, int out',@total out
-----------------------------------
return @total
实例三
加入一笔记录到表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
*/