Re: [PHP-DB] Run SQL-Server command using PHP

2004-02-12 Thread Robert Twitty
For MSSQL databases use the following syntax for executing a stored procedure: mssql_query( "EXEC sp_name param1, param2, param3, ..." ); Another alternative is to use the mssql_init(), mssql_bind() & mssql_execute() functions. Also, better support for executing MS-SQL stored procedures is a

Re: [PHP-DB] Run SQL-Server command using PHP

2004-02-12 Thread Ricardo Lopes
You can use something like: SELECT MyFunction(); Thinks works on mySQL, i'm not sure if it works on mssql but you can give it a try. Tanks to Alban Médici (NetCentrex) who told me this a month ago on this list :) - Original Message - From: "indra Siregar" <[EMAIL PROTECTED]> To: <[EMAIL