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?

You mean something like EXEC mySP @tname=N'mytable' and then mySP executes a query on the table mytable? — VolkerK
– VolkerK, Commented Jan 13, 2010 at 22:24
No, I actually mean passing in the data which represents the a table as the table value parameter. — AdamA
– AdamA, Commented Jan 14, 2010 at 13:29

MartW · Accepted Answer · 2010-01-13 22:30:55Z

5

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.

answered Jan 13, 2010 at 22:30

MartW

12.6k3 gold badges46 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

AdamA Over a year ago

A few follow up notes: First, a note that the above referenced driver is the microsoft php driver, but not the driver ("mssql") many of us user which come standard with the php installation and used for cross platform reasons. Although tvps are currently not supported by the driver as something you can pass from a php data type. We did find a work around. If the tvp "TYPE" is already created in the database, then you can declare in a query a variable of this type and insert rows into it. You can then subsequently use this variable as a parameter to an execute command of the stored proc.

Collectives™ on Stack Overflow

Php SQL Server table value parameter

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest