var conn = new ActiveXObject("ADODB.Connection");
var cmd = new ActiveXObject("ADODB.Command");
var sqlQurey;
var connectionString = "Provider=SQLOLEDB.1; Data Source=" + exceptionDBServer + "; User ID=" + userID +
" ;Password=" + password + "; Initial Catalog=" + exceptionDB;
conn.open(connectionString);
sqlQurey = "DECLARE @return_value int exec @return_value=storedProName'" + pram1+ "','" + pram2+ "','" + pram3+
"','" + pram4+ "'," + pram5+ "," + pram6;
cmd.ActiveConnection = conn;
cmd.CommandType = 1;
cmd.CommandText = sqlQurey;
cmd.Execute();
cmd.close;
conn.close;在JScript代码中我怎样才能得到@return_value的值,比如在代码中var out_pram;把@return_value傅给out_pram
var cmd = new ActiveXObject("ADODB.Command");
var sqlQurey;
var connectionString = "Provider=SQLOLEDB.1; Data Source=" + exceptionDBServer + "; User ID=" + userID +
" ;Password=" + password + "; Initial Catalog=" + exceptionDB;
conn.open(connectionString);
sqlQurey = "DECLARE @return_value int exec @return_value=storedProName'" + pram1+ "','" + pram2+ "','" + pram3+
"','" + pram4+ "'," + pram5+ "," + pram6;
cmd.ActiveConnection = conn;
cmd.CommandType = 1;
cmd.CommandText = sqlQurey;
cmd.Execute();
cmd.close;
conn.close;在JScript代码中我怎样才能得到@return_value的值,比如在代码中var out_pram;把@return_value傅给out_pram
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货