php – how execute a sqlsrv stored procedure

  database, php, sqlsrv

i have success connection to sqlsrv in my php script:

$name = 'SERVERNAME';
$db  = 'DBNAME';
$par = array("Database"=>$db);

$conn = sqlsrv_connect($name, $par);

Also i have procedure code looks like:

Declare @dt datetime;
SET @dt = GETDATE();
EXEC oik..SrezLTGES @Cat = 'Ë', @Ids = '140539,140540,140589,150395,180395,180396,180445',@Time = @dt

enter image description here

I don’t know, how yo execute this query in php. Any ideas?

Source: Ask PHP

LEAVE A COMMENT