SP's in MSSQL

[Anon]

Hi, could you confirm us if is it possible to execute stored procedures in MSSQL 7 from PHP/Linux?

Thank you folks.

Juan.
mailto:[e-mail]

[jordanj]

I don't see why not.. All you are doing normally, is passing an SQL statement to the SQL server.. Since Stored Procedures reside in the SQL server it should recognize them and execute them when encountered.. I, however, am not the definitive word on the subject.

[steved]

sp_columns is a MSSQL supplied stored procedure that returns information about the columns in a table. I'm still using MSSQL 6.5, but after I have established my connection I can execute the stored procedure as follows:

$query = "exec sp_columns $my_table_name"
$rs = odbc_exec($conn, $query);

It is then just a matter of stepping through the record set ($rs) to get the results.