<?php $hostname = "tszzp"; $dbuser = "sa"; $dbpasswd = "";
$id = mssql_connect($hostname,$dbuser,$dbpasswd) or die("无法连接数据库服务器!"); //printf("%d<BR>\n", $id); $db = mssql_select_db("stock",$id) or die("无法连接stock数据库!"); $stockcode=''''600600''''; $id = 0; $msg = 0; //printf("%d<BR>\n", $db); //$query = "exec sp_test @code=''''600028'''',@id=0,@msg=''''000000''''"; $query = "declare @result int, @id int, @msg varchar(20)\n"; $query.="exec @result=sp_test\n"; $query.="\"$stockcode\",\n"; $query.="@id output,\n"; $query.="@msg output;\n"; $query.="select @result result, @id id, @msg msg"; /*$query = "declare @result int, @id int, @msg varchar(20)\n"; $query.="exec @result=sp_test\n"; $query.="\"$stockcode\",\n"; $query.="@id output,\n"; $query.="@msg output;\n"; $query.="select @result result, @id id, @msg msg"; *///$query = "update test set stockname=''''2test'''' where stockcode=''''600028''''"; //$query = "insert into test(stockcode,stockname,id) values (''''600028'''',''''test'''',13)"; //$query = "select * from test where stockcode=''''600028''''"; //$query = "select 0 where 1=0 "; $rresult = mssql_query($query) or die("无法执行SQL:$query"); $arr = mssql_fetch_array($rresult); print $result; print "<br>\n"; printf("%d, %d, %s<br>\n", $arr[result], $arr[id], $arr[msg]); printf("%d, %s<br>\n", $id, $msg); //$stock = mssql_fetch_array($result); //$name = $stock[id]; //print $name; //print "abc";
?>
[Access]sql随机抽取记录 [Access]ASP&SQL让select查询结果随机排序的实现方法 [系统软件]SQL语句性能优化--LECCO SQL Expert [C语言系列]SQL Server到DB2连接服务器的实现 [C语言系列]SQL Server到SYBASE连接服务器的实现 [C语言系列]SQL Server到SQLBASE连接服务器的实现 [C语言系列]SQL Server连接VFP数据库的实现 [C语言系列]ASP+SQL Server之图象数据处理 [C语言系列]SQL Server连接ACCESS数据库的实现 [C语言系列]DBA的最佳选择—图形界面还是T-SQL命令?
|