Finally did it.. 🙂
Its as simple as (a+b)(a-b) ;). But the thing is we need to know how to call it exactly( i mean a proper syntax).
As mssql_connect is not supported for php5+, i found some difficulty to find the proper syntax of stored procedures for sqlsrv. Finally the code is here:
$query = “sp_Employee”;
$params = array();
$result1 = sqlsrv_query($conn, $query, $params);
while ($result2 = sqlsrv_fetch_array($result1))
Output: list all employees first name in that database 🙂