hi,
Here we can see to execute SP from PHP page

Executing a stored procedure with PHP and the mssql_xxx set of functions is easy. To execute a stored procdure that accepts no parameters and doesn't return a value, we only need to make use of the mssql_init and mssql_execute functions.

To create SP

GO

CREATE PROC sp_test

AS

-- Add a record to the shippers table

INSERT INTO test(CompanyName, Phone)

VALUES('Buddies Infotech', '044-43009605');

To execute from PHP page

<?php

$myServer = "localhost";

$myUser = "sa";

$myPass = "";

$myDB = "test";

$s = @mssql_connect($myServer, $myUser, $myPass)

or die("Couldn't connect to SQL Server on $myServer");

$d = @mssql_select_db($myDB, $s)

or die("Couldn't open database $myDB");

$query = mssql_init("sp_test", $s);//call SP

$result = mssql_execute($query);//Execute the SP as a query

?>

__________________
With,
J. Jeyaseelan
Everything Possible

We can also run our stored procedure using query analyzer with the following code:
use test
EXEC sp_test

If we have any param it should give along with

like
EXEC sp_test 2

Here 2 is the param sent to the SP

__________________
With,
J. Jeyaseelan
Everything Possible