CREATE PROCEDURE sp_addnewhuamn  
@add_name char (20),
@add_sex char(2),
@add_logid bigint(8),
@add_birthday datatime(8),
@add_age int(4),
@add_xueli char(10),
@add_mingzhu char(30),
@add_marrige char(10),
@add_photo image(16),
@add_prolitics char(10),
@add_sfzid char(20),
@add_jiguan char(25),
@add_cjgzsj char(10),
@add_gl char(10),
@add_jrbdwsj char(10),
@add_bdwgl char(10),
@add_gzlb char(10),
@add_depment char(20),
@add_zhiwu char(30),
@add_school char(30),
@add_specialy char(20),
@add_finishtime datetime(8),
@add_tel char(20),
@add_mobtel char(12),
@add_address char(50),
@add_postnum char(6),
@add_resume nchar(1000)
AS
   insert into db_human(name,sex,logid,birthday,age,xueli,mingzhu,marrige,photo,prolitics,sfzid,jiguan,cjgzsj,gl,jrbdwsj,bdwgl,gzlb,depment,zhiwu,school,specialy,finishtime,tel,mobtel,address,postnum,resume) values (@add_name,@add_sex,@add_logid,@add_birthday,@add_age,@add_xueli,@add_mingzhu,@add_marrige,@add_photo,@add_prolitics,@add_sfzid,@add_jiguan,@add_cjgzsj,@add_gl,@add_jrbdwsj,@add_bdwgl,@add_gzlb,@add_depment,@add_zhiwu,@add_school,@add_specialy,@add_finishtime,@add_tel,@add_mobtel,@add_address,@add_postnum,@add_resume) 
GO
最后一个参数不需要逗号的