我尝试将序列号插入SQL表
问题描述：
我正在尝试使用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?