===VB+SQL问题:将数据类型转换为datetime出错?在线等===
CREATE PROCEDURE updateAll
(
...
@birthday datetime,
...
)
AS
update test
set
...
birthday = @birthday,
...
where
...
GO
------------------------------
...
cmd.Parameters.Append cmd.CreateParameter("@birthday", adDate)
...
cmd.Parameters("@birthday").Value = dtpBirthday.Value
...
cmd.execute
其它调试过均无错, 运行cmd.execute时提示出错:
runtime error '-2147217931(80040e07)'
将数据类型转换为datetime出错
HELP! 在线等待...
(
...
@birthday datetime,
...
)
AS
update test
set
...
birthday = @birthday,
...
where
...
GO
------------------------------
...
cmd.Parameters.Append cmd.CreateParameter("@birthday", adDate)
...
cmd.Parameters("@birthday").Value = dtpBirthday.Value
...
cmd.execute
其它调试过均无错, 运行cmd.execute时提示出错:
runtime error '-2147217931(80040e07)'
将数据类型转换为datetime出错
HELP! 在线等待...
...全文
请发表友善的回复…
发表回复