我尝试将序列号插入SQL表 [英] I am try to insert sequence numbers into a SQL table

问题描述

我正在尝试使用sql将序列号插入表中，但它只插入一条记录



我尝试过：

I am trying to insert a sequence number into a table using sql but it is only inserting one record

What I have tried:

alter PROCEDURE NumGen
(
@Numgen BIGINT
) 

AS
DECLARE @Counter BIGINT
SET @Counter = 1000

WHILE @Counter = @Numgen
BEGIN 
INSERT INTO dbo.NumberGen
(
    Num
)
SELECT  @Counter
	SET @Counter = @Counter + 1 ;
END 

SELECT * FROM dbo.NumberGen

推荐答案

查看代码：

Look at your code:

SET @Counter = 1000
WHILE @Counter = @Numgen
BEGIN  
   ...
   SET @Counter = @Counter + 1 ;
END

如果你开始要求上千行，它只会插入一行...

或许< ;,< =，> =或>会更好吗？

It will only insert one row, if you start by asking for a thousand...
Perhaps <, <=, >=, or > would be better?

这篇关于我尝试将序列号插入SQL表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！