How to execute a stored procedure with table valued parameters?

I am trying to execute a stored procedure with Table Valued Parameters. Trying to pass SqlParamter object with SqlDbType as Structured seems to be not working with ExecuteStoredProcedure().

Comments

  • Also noticed that, SPs with table valued parameters are missing in list of Stored Procedures on left pane.
  • Yes, this is not supported at present.
  • Any news on this? It has been 7 months
  • Another thought: it would save some time for others if the stored procedure could at least be seen in the tree with some indication that it can not be used.
    To simply not have it listed is not good. You start looking at permissions etc which is all a waste of time
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!