Php SQL Server table value parameter

Question

I am using php against SQL Server 2008 using the mssql driver. Anyone know of a way to pass a table value parameter into stored procedure?

Answer

Table-valued parameters are not yet supported by the PHP MSSQL Driver.

You’ll have to try something else, like converting your TVP into XML and passing it as a stream.

Accepted Answer

Table-valued parameters are not yet supported by the PHP MSSQL Driver.You&#8217;ll have to try something else, like converting your TVP into XML and passing it as a stream.

Advertisement

Answer