what is this erroer Message ?

[Arun Wadhawan]

whatisthe meenign of this error message in general ?

[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would
be truncated.
Kind regards
Arun

[Erland Sommarskog]

[posted and mailed, please reply in news]

Arun Wadhawan (aw****@swissonline.ch) writes:

whatisthe meenign of this error message in general ?

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

Run this repro in Query Analyzer, to get the idea:

CREATE TABLE truncation (a varchar(5) NOT NULL)
go
SET NOCOUNT OFF
SET ANSI_WARNINGS ON
go
INSERT truncation (a) VALUES ('12345')
INSERT truncation (a) VALUES ('ABCDEF')
go
SET ANSI_WARNINGS OFF
go
INSERT truncation (a) VALUES ('12345')
INSERT truncation (a) VALUES ('ABCDEF')
go
SELECT * FROM truncation

Notes:

1) You never get this error when you assign to parameters or variables,
only when you insert or update data in tables.

2) While setting ANSI_WARNINGS off causes SQL Server to keep silent,
I recommend using this only as a last resort, as there are other
features in SQL Server that requires this setting to be on. Also,
changing this setting in a stored procedure causes recompilation
which can be a performance issue.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp