Toad World® Forums

Toad-SS 5.5.0.1073 Code Complete get lost on simple where clause

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

hfreeman@msn.com

678-414-0090 my cell Primary

hank.freeman50 via Skype

image001.gif

image002.jpeg

image008.jpeg