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 qwnbcOut
exec qwnbcOut 'Àî%'