create proc insert_student
(
@name char(10),
@sex char(10),
@age char(10),
@nation char(10),
@visage char(10),
@shcool_age nvarchar(50),
@shcool nvarchar(50),
@class nvarchar(50),
@professional nvarchar(50),
@graduate_year char(10),
@tel char(10),
@qq char(10),
@email nvarchar(50),
@address nvarchar(50),
@job nvarchar(50),
@re nvarchar(50)
)
as
insert into DPstudent(name,sex age,nation,visage,shcool_age,shcool,class,professional,graduate_year,tel,qq,email,address,job,re) values(@name,@sex,@age,@nation,@visage,@shcool_age,@shcool,@class,@professional,@graduate_year,@tel,@qq,@email,@address,@job,@re)
go

解决方案 »

  1.   

    insert into DPstudent([name],sex,age,nation,visage,shcool_age,shcool,class,professional,graduate_year,tel,qq,email,address,job,re) values....
      

  2.   

    当然有错,你看看INSERT这的SEX和AGE是两个字段还是连在一起的,两个字段要用“,”分隔
    create proc insert_student
    (
    @name char(10),
    @sex char(10),
    @age char(10),
    @nation char(10),
    @visage char(10),
    @shcool_age nvarchar(50),
    @shcool nvarchar(50),
    @class nvarchar(50),
    @professional nvarchar(50),
    @graduate_year char(10),
    @tel char(10),
    @qq char(10),
    @email nvarchar(50),
    @address nvarchar(50),
    @job nvarchar(50),
    @re nvarchar(50)
    )
    as
    insert into DPstudent(name,sex,age,nation,visage,shcool_age,shcool,class,professional,graduate_year,tel,qq,email,address,job,re) values(@name,@sex,@age,@nation,@visage,@shcool_age,@shcool,@class,@professional,@graduate_year,@tel,@qq,@email,@address,@job,@re)
    go