Re: Run SQL-Server command using PHP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux