CREATE PROCEDURE changepeople
-- Add the parameters for the stored procedure here
AS
declare @colum int
declare @id int
set @colum=1
while @colum<=100
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
insert into people values('aa','bb','cc','dd','ee','ff','gg','hh')
set @colum =@colum+1
-- Insert statements for procedure here
END
GO
-- Add the parameters for the stored procedure here
AS
declare @colum int
declare @id int
set @colum=1
while @colum<=100
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
insert into people values('aa','bb','cc','dd','ee','ff','gg','hh')
set @colum =@colum+1
-- Insert statements for procedure here
END
GO
扫一扫
1606
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
