存储过程是T-SQL语句和流程控制语句的集合。用于大型数据库系统的开发和应用中。
创建存储过程
use[database_name]
go
create procedure pro_name
as
select * from tb1 where id >1001
go
执行存储过程
use[database_name]
go
exec procedure_name
go
创建带有参数的存储过程
use [database_name]
go
create procedure pro_name
@id int
as
select * from tb1 where id=@id
go
执行带输入参数的存储过程
use [database_name]
go
exec pro_name @id=1005
go
创建带输出参数的存储过程
use[database]
go
create procedure pro_name
@count int output
as
select @count=count(*) from tb1 where id >1001
go
执行带输出参数的存储过程
declare @count int
exec pro_name @count output
print @count
创建带输入输出参数的存储过程
use [database]
go
create procedure pro_name
@id int,
@count int output
as
select @count=count(*) from tb1 where id>@id
go
执行带输入输出参数的存储过程
use [database]
go
declare
@count int
exec pro_name
@id=N'1001',
@count =@count output
select @count=N'@count'
go