sql server 存储过程
create procedure ModifyPrice
(
@num varchar(20)
)
as
update haha set id=id+@num;
exec ModifyPrice @num=10;
go
create proc GetCount
(
@count int output
)
as
declare @num int;
select @num=COUNT(*) from haha;
set @count=@num;
declare @mycount int;
exec GetCount @count = @mycount output;
print @mycount;
go
create proc createuser
(
@username varchar(100)
)
as
declare @namelen int
set @namelen = len( @username );
if @namelen >= 5
return 0
else
return 1;
declare @returnValue int;
exec @returnValue= createuser @username='1';
print @returnValue