sql存储过程基本语法

create Procedure GetUserAccount
@UserName nchar(20),
@UserID int output
as
if(@UserName>5)
select @UserID=COUNT(*) from usertypes where id>1
else
set @UserID=1000
return @@rowcount