SQL Server string longer than 8000 characters

How to manage SQL Server strings with more than 8000 characters without errors? Using SQL Server string longer than 8000 characters with VARCHAR and NVARCHAR fields and explicit lenght is not possible. Indeed the explicit declarations are limited to 8000 characters with SQL Server. Handle text fields longer than 8000 characters and you get the following message, The text, ntext, and image data types … Continue reading SQL Server string longer than 8000 characters