Transact-SQL reference for using DECLARE to define local variables for use in a batch or procedure. Variables are declared in the body of a batch or procedure with the DECLARE statement and are ...

This statement can only be embedded in an application program. It is not an executable statement. It must not be specified in REXX. SQL statements cannot be included within the declare section.