添加存储过程

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