DECLARE @Age INT = 26
DECLARE @qty INT = 0
WHILE @Age <= 238
BEGIN
SET @qty = (SELECT TOP 1 Quantity FROM FMS.T_FeedPlanItem WHERE FromDOA = @Age )
INSERT INTO dbo.T_table VALUES (7,@Age,@Age,20001,@qty)
INSERT INTO dbo.T_table VALUES (7,@Age,@Age,20002,@qty)
INSERT INTO dbo.T_table VALUES (7,@Age,@Age,20003,@qty)
INSERT INTO dbo.T_table VALUES (7,@Age,@Age,20004,@qty)
INSERT INTO dbo.T_table VALUES (7,@Age,@Age,20006,@qty)
INSERT INTO dbo.T_table VALUES (7,@Age,@Age,20007,@qty)
SET @Age = @Age + 1
END
sql 循环插入数据
最新推荐文章于 2023-01-05 20:11:12 发布