[日常工作]偷懒创建一个存储过程进行模拟工作.

create procedure rpadurabletest
AS
declare @a bigINT
set @a=1
while @a<1000
begin
INSERT INTO RPAtask VALUES (137898293650000+@a,'1',getdate(),getdate(),getdate(),getdate(),' ')
INSERT INTO RPARuncase VALUES (newid(),137898293650000+@a,' ','银行对账','[{"Name":"DWBH","Value":"0101"},{"Name":"KJND","Value":"2018"},{"Name":"KJQJ","Value":"2"},{"Name":"BHWJZ","Value":"0"},{"Name":"HBFZ","Value":"0"}]','1','1',getdate(),getdate(),getdate(),'')
commit;
WAITFOR DELAY '0:6:0' ;
set @a=@a+1
end

发现自己真够懒的 不过存储过程的语法忘的太快了.