我是一个数据存储方便做的新手,今天碰到一个问题,找了好久没有看出来,
还请高手指点,在线等!SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GOCREATE 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
)GOSET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GOSET 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
GOSET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GOCREATE 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,
@zkbl,
@zje,
@xj,
@sq,
@bz
)GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GOSET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GOCREATE PROCEDURE sp_setup
(
@sp_no char(8),
@sp_name char(30),
@sp_gg char(30),
@sp_kiloprice numeric(12,2),
@sp_price numeric(12,2),
@splb char(30),
@bz char(255)
)
AS
insert sp
(
sp_no,sp_name,sp_gg,sp_kiloprice,sp_price,splb,bz
)
values
(
@sp_no,@sp_name,@sp_gg,@sp_kiloprice,@sp_price,@splb,@bz
)GOSET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GOSET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GOCREATE PROCEDURE user_setup
(
@user_no char (8),
@user_name char (30),
@dept_name char (30),
@user_pwd char (30))
AS
insert user
(
user_no,
user_name,
dept_name,
user_pwd,
user_time,
)
values
(
@user_no,
@user_name,
@dept_name,
@user_pwd,
@user_time,
)GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO报错误信息如下:
服务器: 消息 170,级别 15,状态 1,过程 kh_setup,行 21
第 21 行: '@kh_name' 附近有语法错误。
服务器: 消息 156,级别 15,状态 1,过程 user_setup,行 11
在关键字 'user' 附近有语法错误。
还请高手指点,在线等!SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GOCREATE 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
)GOSET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GOSET 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
GOSET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GOCREATE 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,
@zkbl,
@zje,
@xj,
@sq,
@bz
)GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GOSET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GOCREATE PROCEDURE sp_setup
(
@sp_no char(8),
@sp_name char(30),
@sp_gg char(30),
@sp_kiloprice numeric(12,2),
@sp_price numeric(12,2),
@splb char(30),
@bz char(255)
)
AS
insert sp
(
sp_no,sp_name,sp_gg,sp_kiloprice,sp_price,splb,bz
)
values
(
@sp_no,@sp_name,@sp_gg,@sp_kiloprice,@sp_price,@splb,@bz
)GOSET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GOSET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GOCREATE PROCEDURE user_setup
(
@user_no char (8),
@user_name char (30),
@dept_name char (30),
@user_pwd char (30))
AS
insert user
(
user_no,
user_name,
dept_name,
user_pwd,
user_time,
)
values
(
@user_no,
@user_name,
@dept_name,
@user_pwd,
@user_time,
)GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO报错误信息如下:
服务器: 消息 170,级别 15,状态 1,过程 kh_setup,行 21
第 21 行: '@kh_name' 附近有语法错误。
服务器: 消息 156,级别 15,状态 1,过程 user_setup,行 11
在关键字 'user' 附近有语法错误。
GO
SET ANSI_NULLS ON
GOCREATE 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
)GOSET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GOSET 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
GOSET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GOCREATE 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,
@zkbl,
@zje,
@xj,
@sq,
@bz
)GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GOSET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GOCREATE PROCEDURE sp_setup
(
@sp_no char(8),
@sp_name char(30),
@sp_gg char(30),
@sp_kiloprice numeric(12,2),
@sp_price numeric(12,2),
@splb char(30),
@bz char(255)
)
AS
insert sp
(
sp_no,sp_name,sp_gg,sp_kiloprice,sp_price,splb,bz
)
values
(
@sp_no,@sp_name,@sp_gg,@sp_kiloprice,@sp_price,@splb,@bz
)GOSET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GOSET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GOCREATE PROCEDURE user_setup
(
@user_no char (8),
@user_name char (30),
@dept_name char (30),
@user_pwd char (30),
@user_time char (30))
AS
insert [user]
(
user_no,
[user_name],
dept_name,
user_pwd,
user_time
)
values
(
@user_no,
@user_name,
@dept_name,
@user_pwd,
@user_time
)GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
(
@kh_no
@kh_name
@kh_addr
@yzbm
@kh_tel
@kh_mobile
@user_name
@bz
)
需要逗号user -> [user]
服务器: 消息 137,级别 15,状态 2,过程 user_setup,行 27
必须声明变量 '@user_time'。
GetRkno = Format(Now, "yymmddhhmmss")
Randomize
GetRkno = GetRkno & Int((99 - 10 + 1) * Rnd + 10)
End Function
这个函数有什么用!