在sql中使用用户定义的表类型时出错->操作数类型冲突：varchar与“用户定义的表类型”不兼容

我认为以下代码可以帮助您

CREATE TYPE [dbo].[myUserTable] AS TABLE([Id] [nvarchar](10) NOT NULL);

CREATE PROCEDURE [dbo].FETCHUSER
@USERS [myUserTable] READONLY,
@Firstname VARCHAR(MAX)
AS
BEGIN
    SELECT *
    FROM   UserTable    AS ut
           JOIN @USERS  AS mt
                ON  mt.Id = ut.Id;
END
GO


DECLARE @users [myUserTable]

INSERT INTO @users
VALUES
   (
    '1'
   ) ,
   (
    '2'
   ) 

EXEC FETCHUSER @users,
     'yourFirstName'