Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

Cross database insert breaks auto-complete

StormRiderStormRider Posts: 26
edited November 5, 2013 8:07AM in SQL Prompt
insert into [AnotherDB].dbo.summarytable
select * from SaleOrder so inner join SaleOrderDetail sod on ...

at this point SQLPrompt is unable to generate suggestions for the join condition, nor is it able to generate suggestions for the select fields.

cross database selects work just fine:
select * from [AnotherDB].dbo.summarytable s inner join SaleOrder so on ...

This generates a s.SaleOrderID = so.SaleOrderID suggestion.

SQL Prompt


Sign In or Register to comment.