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