[Solved] String or binary data would be truncated when using it in a stored procedure

by


You are trying to insert 5 length character(‘dfdfg’) into your 1 length column [Access] [nvarchar](1).

Increase the value of your column in Table type.

CREATE TYPE [dbo].[AccessLevel] AS TABLE(
  [RoleId] [int] NULL,
  [Access] [nvarchar](25) NULL,
  [IsDelete] [bit] NULL
 )
GO

solved String or binary data would be truncated when using it in a stored procedure