Can we Pass table valued parameters and normal params like integer,varchar etc..to a single stored procedure?If we can then how to pass them? I currently have the following
ALTER PROCEDURE InsertData
@M3 M3 READONLY
when i pass params from front end it gives me error " String or binary data would be truncated.The data for table-valued parameter "@M3" doesn't conform to the table type of the parameter.The statement has been terminated."