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 available
in the odbtp extension at http://odbtp.sourceforge.net. For example, take
a look at http://odbtp.sourceforge.net/insertints_php.html.
-- bob
On Thu, 12 Feb 2004, Ricardo Lopes wrote:
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 PROTECTED]
Sent: Thursday, February 12, 2004 12:47 AM
Subject: [PHP-DB] Run SQL-Server command using PHP
How I can run sql-server using PHP, like sp (stored procedure) in
SQL-Server
ThankYou
--
Indra Siregar
IF02008
Politeknik Informatika Del
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php