Forum Discussion

SezMe's avatar
SezMe
Copper Contributor
Feb 01, 2024

How to Enter Table data in SSMS

I am having problems with a Stored Procedure that has a table as one of the inputs.  From the client side I provide the data using a SqlDbType.Structured parameter.  I would like to test the procedure using SSMS however I don't know what to enter in the "Value" column for the table parameter.

 

Thanks in advance.

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Feb 02, 2024

     

    I don't know what to enter in the "Value" column for the table parameter.

    SezMe , we also don't know what to enter and we can't guess it, because you didn't provided any usefull detail information about it.

    • SezMe's avatar
      SezMe
      Copper Contributor
      Feb 02, 2024

      olafhelperLet me rephrase the question: "... however I don't know what to enter in the "Value" column for the table parameter."

      to:

      "...however I don't know how to enter a table into the "Value" column for the table parameter.

       

Resources