Tag Info

New answers tagged


If the issue you are having is Truncation you can use this XML approach that gets around most of the issues with XML entitisation. declare @VeryLongText nvarchar(max) = ''; SELECT top 100 @VeryLongText = @VeryLongText + ' ' + OBJECT_DEFINITION(object_id) FROM sys.all_objects WHERE type='P' and is_ms_shipped=1 SELECT LEN(@VeryLongText) SELECT ...

Top 50 recent answers are included