I am not quite answering your question, but wanted to reflect on 70-461. You may please refer to attached.

Accordingly, exams related to SQL Server 2016 are now launched....

My reflection on discussions such as these is been very practical. At the risk of sounding philosophical, i might voice it anyway.

Language features (be it any language) are like tools...

If your version of SQL Server permits, why not just try nvarchar(max)?

If we don't want any row level control, then what I was thinking was much simpler than this, actually.

It is something like:

DECLARE @sql NVARCHAR(3000) = ''

DECLARE @RoleName NVARCHAR(100)

SELECT...

This is nice. However, over time I have also started using another approach where we can declare a nvarchar(max) variable at the beginning of the script and then append it...