if exists (select * from sysobjects where name = ‘UP_ADD‘)
drop proc UP_ADD
go
create proc UP_ADD
(
@tname varchar(30) ,
@tsex varchar(10) ,
@tage varchar(10) ,
@tzuo varchar(50) ,
@lid int
)
as
insert into struggling values (@tname,@tsex,@tage,@tzuo,@lid)
go
原文：https://www.cnblogs.com/JXSBoKeYuan/p/9387493.html