- 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
来源: http://www.bubuko.com/infodetail-2705553.html