例如：我想从Category(表)中将100到3000插入categoryID(列)
非常感谢你
DECLARE @id INT SET @id = 100 WHILE (@id <= 300) BEGIN insert into categories (categoryID) values (@id) SELECT @id = @id + 1 END
