CREATE PROCEDURE [Meter_XiaoQu] 
@Datebegin datetime,
@Dateend datetime
as
set nocount on  ------------***加上此句
declare @rc int
set @rc=datediff(month,@datebegin,@dateend)+1
set rowcount @rc
select sn=identity(int,0,1) into #t from syscolumns
set rowcount 0
select year=year(dateadd(month,sn,@datebegin)),month=month(dateadd(month,sn,@datebegin))
   into #t1 from #t
select * from #t1GO