Silent truncation in MSSQL

Posted on by Michael Dyhr Iversen

How Can We Help?

Created On
byMichael Dyhr Iversen
You are here:
< Back

The thing you have to do is set ANSI WARNINGS to OFF You can do that by calling

set ANSI_WARNINGS OFF

I have also written a practical example:

create table bla(id varchar(2))
go
 
insert bla values ('123') --fails

set ANSI_WARNINGS OFF

insert bla values ('123') --succeeds

Do remember to turn the ANSI warnings back ON when you are done. You can do so by calling:

set ANSI_WARNINGS ON