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" <if02008@xxxxxxxxxxxxxxxxxx>
> To: <php-db@xxxxxxxxxxxxx>
> Sent: Thursday, February 12, 2004 12:47 AM
> Subject: 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
