Re: How to ensure column names are double quoted while using execute format when building a stored procedure?

[David G. Johnston]

On Thu, Dec 16, 2021 at 3:04 PM Adrian Klaver <adrian.kla...@aklaver.com>
wrote:

>
> This:
>
> 'count of nulls in "UNIQUE_REFERENCE_NUMBER"'
>
> is just plain incorrect syntax.
>

<single quote>count of nulls in <double quote>UNIQUE_REFRENCE_NUMBER<double
quote><single quote>

That is not invalid syntax.  It is just literal single quoted text - the
double quotes are simply characters in the string.

David J.