how to get the full resultset from SSMS

by

I cast it to XML

select @variable_with_long_text
 as [processing-instruction(x)] FOR XML PATH

The processing-instruction bit is there to stop it entitising characters such as < to &lt;

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Making a dynamic pivot table but without using the fiddle
  3. Get top 1 row of each group
  4. How to return only the Date from a SQL Server DateTime datatype
  5. How to cast the DateTime to Time
  6. Referring to a Column Alias in a WHERE Clause
  7. Convert Datetime column from UTC to local time in select statement
  8. How to implement LIMIT with SQL Server? [duplicate]
  9. Why is SQL Server losing a millisecond?
  10. converting Epoch timestamp to sql server(human readable format)
  11. Find a string by searching all tables in SQL Server
  12. What are Covering Indexes and Covered Queries in SQL Server?
  13. How do I split a delimited string so I can access individual items?
  14. Common Table Expression, why semicolon?
  15. Add a summary row with totals
  16. T-SQL split string based on delimiter
  17. Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
  18. Why use Select Top 100 Percent?
  19. How do I find duplicates across multiple columns?
  20. Calculate business hours between two dates
  21. SQL Server UNION – What is the default ORDER BY Behaviour
  22. How to get last 7 days data from current datetime to last 7 days in sql server
  23. How to check which locks are held on a table
  24. store arabic in SQL database
  25. What is the Null Character literal in TSQL?
  26. SQL Server : SUM() of multiple rows including where clauses
  27. SQL Script to alter ALL Foreign Keys to add ON DELETE CASCADE
  28. SQL Server search using like while ignoring blank spaces
  29. Find last sunday
  30. How to concatenate all columns in a select with SQL Server

Leave a Comment