http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=8118
解决方案 »
- 要做一个“黄金实时报价”功能,寻求思路,谢谢!
- php ajex 自动完成问题
- 当前PHP页面中,执行其他页面程序并返回程序值
- session网页之间不能传值。必须先用session_start();函数
- php 中怎么实现低权限添加的数据要通过高权限的审核才能通过添加呢.....给点思路
- 请教:php中session_start()有何用处?如何使用它.........
- 我想用PHP写一个想CSDN类似的论坛!请求帮助
- 用javacscript输出php内容
- 给我一点思路好吗?
- php正则替换问题
- PHP has encountered an Access Violation at 01557DE7 是什么错误
- 现有短信网站可能出现的BUG?
感恩戴德!!!
CREATE PROCEDURE [procedure]
(
@sval varchar(50) OUTPUT,
@intval int OUTPUT,
@floatval decimal(6,4) OUTPUT
) AS
if @intval is null
select '@intval is null' as answer
else
select '@intval is NOT null' as answer
set @sval='Hello ' + @sval
set @intval=@intval+1
set @floatval=@floatval+1
return 10
参考的php代码:
<?php
$conn=mssql_connect("myhost","user","pwd");
if ($conn) {
mssql_select_db("mydb",$conn);
$stmt=mssql_init("procedure",$conn);
mssql_bind($stmt,"RETVAL",&$val,SQLINT4);
$ival=11;
$fval=2.1416;
$sval="Frank";
mssql_bind($stmt,"@sval",&$sval,SQLVARCHAR,TRUE);
mssql_bind($stmt,"@intval",&$ival,SQLINT4,TRUE);
mssql_bind($stmt,"@floatval",&$fval,SQLFLT8,TRUE);
$result=mssql_execute($stmt);
$arr=mssql_fetch_row($result);
print ("Answer: " . $arr[0] . "
" );
print ("RETVAL = $val ; intval = $ival ; floatval = $fval ; string = $sval");
mssql_close($conn);
}
else print("ooops!");
?>