sp_executesql giving truncate error

• sql_butterfly

  Ten Centuries

  Points: 1264

  More actions

  February 28, 2011 at 6:49 am

  #100355

  Hello Friends, i'm facing an truncation issue while creating statement for sp_executesql. Though I'm using nvarchar(max), its still giving me error.

• RP_DBA

  SSCertifiable

  Points: 5116

  More actions

  February 28, 2011 at 11:38 am

  #1292490

  Could the error be related to the actual statement sp_executesql is executing?

  Example:

  DECLARE @sql NVARCHAR(MAX)

  SET @sql = 'DECLARE @tbl TABLE (Test CHAR(1))'

  SET @sql = @sql + 'INSERT INTO @tbl VALUES (''ABCD...'')'

  EXEC sp_executesql @sql

  Generates:

  Msg 8152, Level 16, State 14, Line 1

  String or binary data would be truncated.

  The statement has been terminated.

  _____________________________________________________________________
  - Nate

  @nate_hughes