存储过程参数

存储过程as前的参数是从外边传入的,as后的参数是内部参数.

 

CREATE PROCEDURE [dbo].[sp_InsertYear]
@StartYear int,
@EndYear int
AS
declare @Count int
select @Count = Count(*) from T_Year
if @Count > 0
begin
 return
end
else
begin
 while(@StartYear < @EndYear)
  begin
   insert into T_Year([Year]) values(@StartYear)
   set @StartYear = @StartYear + 1
  end
end