存储过程(procedure.sql):
create procedure hello
@yourname varchar(50) = "无名士"
as
select @yourname + ",你好!"
立即学习“PHP免费学习笔记(深入)”;
go
PHP3程序(procedure.php3):
"; echo ""; $query = "exec hello @yourname=\"朋友\""; $rst = mssql_query($query,$db) or die("无法执行SQL:$query"); $fields_num = mssql_num_fields($rst); $i=0; while($i<$fields_num){ $fields[$i] = mssql_field_name($rst,$i); echo " "; while ($record=mssql_fetch_array($rst)) { echo "" . $fields[$i] . " "; $i++; } echo ""; $i=0; while($i<$fields_num){ $value = $record[$fields][$i]]; if($value=="") echo " "; } mssql_free_result($rst); echo ""; mssql_close($server) or die("无法与数据库服务器断开连接!"); ?>"; else echo " " . $value . " "; $i++; } echo "
永久地址:
转载随意~请带上教程地址吧^^











