Forum Discussion

mansoorabid's avatar
mansoorabid
Copper Contributor
Jan 26, 2024
Solved

SQL Query Issue

I have two table  Table1 and Table2      CREATE TABLE [dbo].[Table1]( [ID] [int] IDENTITY(1,1) NOT NULL, [User_Id] [varchar](50) NULL, [counts] [int] NULL, PRIMARY KEY CLUSTERED  ( [ID] ASC...
  • olafhelper's avatar
    Jan 29, 2024
    I get the error “String or binary data would be truncated.”

    As the error message clearly says and the cause is

    [dbo].[Table1] => [User_Id] [varchar](50)

    [dbo].[table2] => [User_Id] [varchar](100)