要在ALM web ui上用的grid做上infinite scroll,目前没啥想法。
需要一个很多defect做实验,今天通过classic ui加了好多,加到28个时候,突然意识到可以写个存储过程做这事。
CREATE PROCEDURE createMultipleBugs AS BEGIN TRANSACTION declare @num int begin set @num = 29 while @num < 500 begin INSERT INTO [default_72_db].[td].[BUG] ( [BG_BUG_ID], [BG_SUMMARY], [BG_DESCRIPTION], [BG_STATUS], [BG_REPRODUCIBLE], [BG_SEVERITY], [BG_DETECTED_BY], [BG_DETECTION_DATE], [BG_BUG_VER_STAMP], [BG_VTS]) VALUES (@num,'sample','sample', 'Open', 'Y','3-High','sa','2013-07-15 00:00:00.000',1,'2013-07-18 10:48:23') set @num = @num +1 end end COMMIT TRANSACTION