存储过程临时表怎循环插入表数据

Question

ALTER PROC [dbo].[getda]
@Year int = 2016
AS
BEGIN
SET NOCOUNT ON;
SET LANGUAGE US_ENGLISH;
DECLARE @TempMonth int,@SYear int,@TempDate NVARCHAR(10);
SET @SYear = @Year;
CREATE TABLE #TempDate
(
RowID INT IDENTITY(1, 1)
,Years NVARCHAR(5)
,Months NVARCHAR(5)
,HandleID INT default(0)
,count int default(0)
);
SET @TempMonth = 1;
WHILE @TempMonth <= 12
BEGIN
SET @TempDate = CONVERT(NVARCHAR(4),@SYear)+ '-' + CONVERT(NVARCHAR(4), @TempMonth) + '-01' ;

         INSERT into #TempDate(Years,Months)
         VALUES  ( @SYear - 2000, SUBSTRING(DATENAME(MONTH, @TempDate), 1, 3));
         SET @TempMonth +=1;
         END
         END
    select * from #TempDate

GO

怎样做到实体表HandleID循环插入
想要的效果

Answer 1

把Insert那句换成：

INSERT into #TempDate(Years,Months,handleId)
VALUES ( @SYear - 2000, SUBSTRING(DATENAME(MONTH, @TempDate), 1, 3),((@TempDate-1)%3 +1)*100);