创建存储过程.sql

SQL数据库的一些基本的操作源码 包括创建存储过程,表,触发器的创建

create procedure salary_dept @dept tinyint,@total money output
 as
select @total=sum(salary)
from employees
where department=@dept

print '该部门的工资总和'+convert(varchar,@total)
execute salary_dept( @total output)
execute sp_help insert_departments_1
drop procedure salary_dept