How to Enter Table data in SSMS

Copper Contributor

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.

2 Replies

 


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.

@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.