我也是这样子做得呀 存储过程文件是 CREATE PROCEDURE hello as delete from user where user_id=3 php文件是 <? $server=mssql_connect("sun","sa","1234") or die("无法连接到服务器") ; $db=mssql_select_db("Epg_community") or die ("无法连接到数据库"); $query="exec hello"; mssql_query($query) or die("无法执行"); mssql_close($server); ?> 总是无法执行,是怎么回事呀
存储过程文件是
CREATE PROCEDURE hello
as
delete from user where user_id=3
php文件是
<?
$server=mssql_connect("sun","sa","1234") or die("无法连接到服务器") ;
$db=mssql_select_db("Epg_community") or die ("无法连接到数据库");
$query="exec hello";
mssql_query($query) or die("无法执行");
mssql_close($server);
?>
总是无法执行,是怎么回事呀
还有,大家如果知道存储过程怎么样返回结果集给php的话,忘告之,感激涕零
一次加100分,满意为止
我的e-mail是
[email protected]
@yourname varchar(50) = "无名士"
as
select @yourname + ",你好!"
go