求救求救,存储过程的问题

Question

id,GGDate,GGNO,FLNO,SQNO,SQDate,Proposer,YSQNO,Addr,SJMan,Agent,AgentMan,BZDate,YXClaim,GKDate,GKNO,Originator,(这里是不是多了一个空格?),GJSQ,GJGB,JRGJDate,Title,Abstract,FLZT

Answer 1

多了一个,号CREATE PROCEDURE InsertBookZLCN
  @TRS_id      VARCHAR(5),
  @TRS_GGDate  VARCHAR(6),
  @TRS_GGNO    VARCHAR(8),
  @TRS_FLNO    VARCHAR(9),
  @TRS_SQDate  VARCHAR(6),
  @TRS_SQNO    VARCHAR(8),
  @TRS_proposer  VARCHAR(50),
  @TRS_YSQNO   VARCHAR(10),
  @TRS_Addr   VARCHAR(50),
  @TRS_SJMan   VARCHAR(50),
  @TRS_Agent  VARCHAR(50),
  @TRS_AgentMan  VARCHAR(50),
  @TRS_BZDate  VARCHAR(6),
  @TRS_YXClaim  VARCHAR(20),
  @TRS_GKDate  VARCHAR(6),
  @TRS_GKNO  VARCHAR(8),
  @TRS_Originator  VARCHAR(20),
  @TRS_GJSQ  VARCHAR(20),
  @TRS_GJGB  VARCHAR(30),
  @TRS_JRGJDate  VARCHAR(6),
  @TRS_TItle  VARCHAR(50),
  @TRS_Abstract  VARCHAR(5000),
  @TRS_FLZT  VARCHAR(5000)
AS
BEGIN
  INSERT INTO BookZLCN
     (id,GGDate,GGNO,FLNO,SQNO,SQDate,Proposer,YSQNO,Addr,SJMan,Agent,AgentMan,BZDate,YXClaim,GKDate,GKNO,Originator,GJSQ,GJGB,JRGJDate,Title,Abstract,FLZT)
  VALUES
     (@TRS_id,@TRS_GGDate,@TRS_GGNO,@TRS_FLNO,@TRS_SQNO,@TRS_SQDate,@TRS_Proposer,@TRS_YSQNO,@TRS_Addr,@TRS_SJMan,@TRS_Agent,@TRS_AgentMan,@TRS_BZDate,@TRS_YXClaim,@TRS_GKDate,@TRS_GKNO,@TRS_Originator,@TRS_GJSQ,@TRS_GJGB,@TRS_JRGJDate,@TRS_Title,@TRS_Abstract,@TRS_FLZT)
END