Parameter Description
value Controls whether the ODBC interface uses call escape syntax for stored procedure calls or converts the calls to driver-specific native SQL syntax.
Values are:
?Yes (Default) The ODBC interface uses call escape syntax for stored procedure calls
?No The ODBC interface converts stored procedure calls to driver-specific native SQL syntax before sending the command to the ODBC driver
都可以已传参数的
create proc proc_Name
@pwd varchar(50),
@name varchar(50)
as
set nocount on
declare @return int
if @name='a' and @pwd='b'
set @return = 1
else
set @return = 0
select result=@return
set nocount off
调用:
datacmd.commandtext="proc_Name" --存储过程名
datacmd.commandtype=4 --标识储存过程
datacmd.parameters(1) = 'b'
datacmd.parameters(2) = 'a'
set rs = datacmd.execute() -执行
if rs("result")=0 then
....
else
......