PHP调用SQLServer的存储过程例子

创建事例：CREATE PROCEDURE [sp_mystoreprocedure] AS select companyname, contactname, city from customers

存储过程：<?php

define (“OLEDB_CONNECTION_STRING”,

“Provider=SQLOLEDB; Data Source=zzb; Initial Catalog=Northwind; User ID=sa; Password=”);

$dbc = new COM(“ADODB.Connection”);

$dbc->Open(OLEDB_CONNECTION_STRING);

$command = “sp_mystoreprocedure”;

$rs = $dbc->Execute($command);

$i = 0; echo ‘

$i += 1;

$fld0 = $rs->Fields(0);

$fld1 = $rs->Fields(1);

$fld2 = $rs->Fields(2);

print ‘

‘;

print $fld0->value;

print ‘

‘;

print $fld1->value;

print ‘

‘;

print $fld2->value;

print ‘

‘; $rs->MoveNext();

}

print ‘

‘; $rs->Close();

?>