Forum Discussion
mansoorabid
Jan 26, 2024Copper Contributor
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...
- Jan 29, 2024I 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)
olafhelper
Jan 29, 2024Bronze Contributor
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)