Toad – SS Auto Complete get lost on typing in the where clause value
BusinessEntityID where the update table is a just Created Temp Table.
This is because the SQL Server Temp Table name is too long for the auto complete
display Window.
Toad-SS should only be concerned with the table name in the update statement or
#HankTest
use AdventureWorks2008R2
go
Select * into #HankTest from HumanResources.Employee
go
select * from #HankTest
go
update #HankTest
set LoginID = 'HfText' + 'adventure-works\ken0'
where BusinessEntityID = 1
go
select * from #HankTest
go
drop table #HankTest
Hank Freeman
Senior SQL Server DBA/Data & Systems Architect
678-414-0090 my cell Primary
hank.freeman50 via Skype