Skip to content

Instantly share code, notes, and snippets.

@gazlu

gazlu/view-large-nvarchar.sql

Created October 27, 2016 23:11
Show Gist options
  • Save gazlu/38aca5de828342feb62b3a9d58107abd to your computer and use it in GitHub Desktop.
Save gazlu/38aca5de828342feb62b3a9d58107abd to your computer and use it in GitHub Desktop.
Download ZIP
View large Nvarchar to debug in sql server
Raw
view-large-nvarchar.sql
DECLARE BULKnvarchar nvarchar(max)
SELECT CAST('<data><![CDATA[' + @BULKnvarchar + ']]></data>' as xml)
-- use tools like 'http://coderstoolbox.net/string/#!encoding=xml&action=decode&charset=us_ascii' this
-- to decode the xml inside data element
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment