- ALTER PROCEDURE dbo.StoredProcedure2
- /*
- 循环添加20000条数据
- */
- AS
- /* SET NOCOUNT ON */
- --SET IDENTITY_INSERT testPROC ON
- declare @i int
- set @i=1
- while @i<=20000
- begin
- insert into testPROC([testid], test1,test2, test3) values(@i, 'aaaaa','bbbbb','ccccc')
- set @i=@i+1
- end
- --SET IDENTITY_INSERT testPROC OFF
- RETURN
存储过程循环添加数据
最新推荐文章于 2024-03-25 17:25:18 发布