sqlserver 存储过程

create database db
use db
create table sampleTable
(
?fId int identity(1,1)? primary key,
?fName varchar(10),
?fGrade int,
)
select * from sampleTable
insert into sampleTable values ('张柏',69);
insert into sampleTable values ('李寻欢',100);
insert into sampleTable values ('李四',100);
--普通存储过程
create proc queryInfo
as
? select * from sampleTable
go

drop proc queryInfo
exec queryInfo
--传入参数--
create proc idIn
@id int
as
? select * from sampleTable where fid =@id
go

drop proc idIn

exec idIn 1

--传入参数--
create proc nameIn
@name varchar(10)
as
? select * from sampleTable where fname =@name
go
exec nameIn '张柏'

--传入、传出参数--
create proc nameOut
@id int,
@name varchar(10) output
as
begin
? select @name=fname from sampleTable where fid =@id

end

drop proc nameOut
declare @name varchar(10)
exec nameOut 1,@name output
select @name

--带通配符的参数
create proc qwnbcOut
@name varchar(10) ='张%'
as
begin
? select * from sampleTable where fname like @name
end

drop proc qwnbcOutexec qwnbcOut '李%'

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!