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),

@Page int,

...