USE [CheckSubject]
GO
/****** Object: StoredProcedure [dbo].[proc_uidlist] Script Date: 05/23/2012 12:29:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[proc_uidlist]
--@para1 nchar(20), --输入参数
--@para2 int = null out --输出参数,供程序使用
as
declare @i int
set @i=1
while @i <5001
begin
insert into plat_uidlist values( '1359941'+@i ,0 ,0 )
--print @i
--注意改变循环变量,以保证不会构成死循环
set @i=@i+1
end
GO
/****** Object: StoredProcedure [dbo].[proc_uidlist] Script Date: 05/23/2012 12:29:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[proc_uidlist]
--@para1 nchar(20), --输入参数
--@para2 int = null out --输出参数,供程序使用
as
declare @i int
set @i=1
while @i <5001
begin
insert into plat_uidlist values( '1359941'+@i ,0 ,0 )
--print @i
--注意改变循环变量,以保证不会构成死循环
set @i=@i+1
end