if (exists (select * from sys.objects where name = 'inser_user'))
drop proc inser_user
go
create proc inser_user( @num int)
as
declare @aa int;
set @aa =1;
while(@aa< 6)
begin
INSERT INTO dbo.users (id,names) VALUES(11,'aaaa');
set @aa=@aa+1;
end
drop proc inser_user
go
create proc inser_user( @num int)
as
declare @aa int;
set @aa =1;
while(@aa< 6)
begin
INSERT INTO dbo.users (id,names) VALUES(11,'aaaa');
set @aa=@aa+1;
end
--调用、执行存储过程
exec inser_user '3';
exec inser_user '3';
select * from users;
delete users
delete users
if (exists (select * from sys.objects where name = 'inser_user'))
drop proc inser_user
go
create proc inser_user( @num int)
as
declare @aa int;
set @aa =1;
while(@aa< 6)
begin
INSERT INTO dbo.users (id,names) VALUES(11,'aaaa');
set @aa=@aa+1;
end
--调用、执行存储过程
exec inser_user '3';
select * from users;
delete users