Return
-
Title
The @ sign for bind variables isn't working if it's undeclared -
Description
If you run a select statement in the editor, such as:
SELECT COUNT (1) TOTALCOUNT
FROM dbo.accounts AS C
WHERE email = @iCLIENT_GRP_ID
There is an error which appears, because @iCLIENT_GRP_ID is not declared. If the following script is run, the it works ok:declare @iCLIENT_GRP_ID int
set @iCLIENT_GRP_ID = 2SELECT COUNT (1) TOTALCOUNT
FROM dbo.accounts AS C
WHERE email = @iCLIENT_GRP_ID
However, if the following script is run, it works without needing to be declared:
SELECT COUNT (1) TOTALCOUNT
FROM dbo.accounts AS C
WHERE email = :iCLIENT_GRP_ID
Is it possible that the same behaviour can happen when using the @ sign as the bind variable?
-
Resolution
WORKAROUND:
Declare the variable, as described above.STATUS:
Enhancement request CR 90737 has been submitted to Development for consideration in a future release of Toad for SQL Server. -
Defect ID
CR 90737