CODEWITHSUNDEEP
sql-server-2008
SuperNES
SuperNES

Reputation: 2810

String or Binary Data Would Be Truncated: NVARCHAR(MAX), SQL Server 2008

I've got a column called description of type NVARCHAR(MAX) - biggest you can have. I need to return this field with quotes around it, so I'm trying to 

SELECT QUOTENAME(description, '"')

This doesn't work - I get a "string or binary data would be truncated error."

My googling tells me that this problem can be solved by using SET ANSI_WARNINGS OFF, but if I do that, I still get the same error anyway.

Normally I would just pull the values into a temp table and use a field that is two characters bigger than the field I'm pulling in, thus ensuring that the QUOTENAME function won't cause any problems. How do I make a column two characters bigger than MAX, though?

Upvotes: 4

Views: 5383

Answers (1)

Martin Smith
Martin Smith

Reputation: 453067

QUOTENAME is a function intended for working with strings containing SQL Server identifier names and thus only works for strings less than or equal to the length of sysname (128 characters).

Why doesn't SELECT '"' + description +'"' work for you?

Upvotes: 5

Related Questions