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 ...

in the Routines window gives an immediate red x syntax error and this message on submission: One or more errors have occurred while processing your request: The ...