Dynamic SQL not producing expected results

• Question

• 

  

  0

  Sign in to vote

  Hello,

  I am having issues with the piece of code below, not returning expected result.

  DECLARE @SQL VARCHAR(MAX)
   , @SQLBase VARCHAR(MAX)
   , @Criteria VARCHAR(25)
  SET @SQLBase = 'This script is testing the use of N'' and is '
  SET @SQLBase = ''PRINT'' + @SQLBase
  EXECUTE (@SQLBase)

  I am having issues with the piece of code below, not returning expected result.

  This script is testing the use of N' and is 

  Can anyone explain why nothing is being returned upon execution and what to do to resolve this?

  Thank you.

  Friday, June 13, 2014 8:15 PM