简单的问题

if object_id('sp_test','P') is not null
   drop procedure sp_test
go
create procedure sp_test 
@p1 int,
@p2 int
as
  select number from master..spt_values where type='p' and number between @p1 and @p2
go
exec sp_test 1,10
go
/*
number
-----------
1
2
3
4
5
6
7
8
9
10

(10 行受影响)


*/