sql语句循环插入
DECLARE @i int
SET @i=1
WHILE(@i<10000000)
BEGIN
SET @i=@i+1
INSERT into l_loan_guar VALUES(1,1,1)
INSERT INTO l_loan_info (loan_cust_id) VALUES('1')
end
插入char类型的需要cast转换一下
sql语句循环插入
DECLARE @i int
SET @i=1
WHILE(@i<10000000)
BEGIN
SET @i=@i+1
INSERT into l_loan_guar VALUES(1,1,1)
INSERT INTO l_loan_info (loan_cust_id) VALUES('1')
end
插入char类型的需要cast转换一下
转载于:https://www.cnblogs.com/ziye/archive/2009/08/18/1548986.html