简单存储过程写法

 

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON

GO
ALTER PROC [dbo].[test]
(
@AA  numeric(30) 
)
AS

DECLARE @total numeric(8,0) 
DECLARE @message varchar(100)

BEGIN

select @total=count(*) from dbo.Skill where ID=@AA  
return  @total

END



declare @i numeric(10,0)
EXEC   @i= [dbo].[test] 1
select @i

简单存储过程的写法，调用代码在下面；