[SQL Server] String or binary data would be truncated.

  • Imprimer

USE [tempdb]
GO

INSERT INTO [dbo].[Table_1] ([CAL1])
VALUES ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa')

 

Msg 8152, Level 16, State 30, Line 8
String or binary data would be truncated.
The statement has been terminated.

DBCC TRACEON(460, 1);

GO

USE [tempdb]
GO

INSERT INTO [dbo].[Table_1] ([CAL1])
VALUES ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa')

DBCC TRACEOFF(460, 1);
GO


Msg 2628, Level 16, State 1, Line 8
String or binary data would be truncated in table 'tempdb.dbo.Table_1', column 'CAL1'. Truncated value: 'aaaaaaaaaa'.
The statement has been terminated.