请教存储过程的问题 http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=8118 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 请哪个好心的大哥结合下边的例子给我作个详细的解释呀!!!!!!感恩戴德!!!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!"); ?> PHP怎么把字符串里<div>变成转义字符 数组相加为什么取出了只有第一个值呢?麻烦各位给看一下。 php如何重排css? 关于PHP下载程序如何支持迅雷 关于PHP5新特性的一些疑问 文件上传及时间输出错误! 请问在linux上面,如何用php实现定时发信阿。 有没有办法将php编译成dll,注册在win32服务器上并在其他php页面中调用。 缺省参数和全局变量的问题 为什么这种socket程序会无限执行sql语句而不被挂起? 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!");
?>