--------根据姓名查询年龄是否超过100
create proc guang
@name varchar(100)
as
declare @val int
select @val=age from liu where name=@name
if(@val>100)
return 1
else
return 0
go
create proc guang
@name varchar(100)
as
declare @val int
select @val=age from liu where name=@name
if(@val>100)
return 1
else
return 0
go