将具有表值参数的多个参数传递给存储过程

我们可以将表值参数和普通参数（如整数，varchar等）传递给单个存储过程吗？如果可以，那么如何传递它们？我目前有以下



ALTER程序InsertData

（

@slno nvarchar（255），

@OrderNo nvarchar（255），

@ M3 M3 READONLY

）



当我从前端传递params它给我错误字符串或二进制数据将被截断。表值参数@ M3的数据不符合参数的表类型。语句已被终止。

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
(
@slno nvarchar(255),
@OrderNo nvarchar(255),
@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."