Toad World® Forums

@variable code completion incorrect

When I use code completion to complete a @variable, the code completion always enters @@variable, even though the list I am choosing from shows @variable.

Hi,

can you please share your step-by-step? it will help to identify the issue. Thanks

I declared a variable and set it with a value.
If I use this variable in a select statement, Code Completion inserts the correct variable.
If I use this variable in an insert into statement, Code Completion inserts an extra ‘@’ ending up with @@variable instead of @variable.

Do you mean the issue happens in syntax like this:

declare @var nvarchar(255);
set @var = ‘’;

insert into A_hundred (Akey) values (@@var

I think this issue is fixed in Toad for SQL Server 6.5