Maybe not the best but I've been using this for years.

Keen to try the methods posted in the article.

USE [*********]

GO

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER OFF

GO

ALTER PROCEDURE [dbo].[ReturnRows]

(

@sql nvarchar(4000),

...