急,在线等!!!一个数据存储过程的问题
我是一个数据存储方便做的新手,今天碰到一个问题,找了好久没有看出来,
还请高手指点,在线等!


SET   QUOTED_IDENTIFIER   ON  
GO
SET   ANSI_NULLS   ON  
GO

CREATE   PROCEDURE   kh_setup  
(
@kh_no   char   (8),                                  
@kh_name   char   (30),          
@kh_addr   char   (40),                                    
@yzbm   char   (6),                                    
@kh_tel   char   (40),
@kh_mobile   char   (50),
@user_name   char   (30),
@bz   char   (255)
)
  AS
insert   kh
(
kh_no,kh_name,kh_addr,yzbm,kh_tel,kh_mobile,user_name,bz
)
values
(
                @kh_no                                  
@kh_name      
@kh_addr                                  
@yzbm                                
@kh_tel  
@kh_mobile  
@user_name  
@bz  
)

GO

SET   QUOTED_IDENTIFIER   OFF  
GO
SET   ANSI_NULLS   ON  
GO

SET   QUOTED_IDENTIFIER   ON  
GO
SET   ANSI_NULLS   ON  
GO


/******   Object:     Stored   Procedure   dbo.kucun_setup         Script   Date:   2003-1-4   10:46:05   ******/

SET   QUOTED_IDENTIFIER   OFF  
GO
SET   ANSI_NULLS   ON  
GO

SET   QUOTED_IDENTIFIER   ON  
GO
SET   ANSI_NULLS   ON  
GO

CREATE   PROCEDURE   kpd_setup
(
@kpd_time   datetime,
@kpd_no   char   (8),
                @user_no   char   (8),
@user_name   char   (30),
@kh_name   char   (30),
@sp_no   char   (8),
                @sp_name   char   (30),
@num   numeric   (10),
@sp_price   numeric(12,   2),
@zkbl   numeric(5,   0),
@zje   numeric(12,   2),
@xj   char   (2),
@sq   char   (2)   ,
@bz   char   (100)
)
  AS
insert   kpd
(
kpd_time,
kpd_no,
user_no,
                user_name,
kh_name,
sp_no,
sp_name,
num,
sp_price,
zkbl,
zje,
xj,
sq,
bz
)
values
(

@kpd_time,
@kpd_no,
@user_no,
                @user_name,
@kh_name,
@sp_no,
@sp_name,
@num,
@sp_price,