← Customer Feedback for Devart Settings and activity 1 result found Ability to specify FROM and JOIN clauses when building complicated UPDATE queries in Query Builder 7 votes Vote Vote Vote Vote We're glad you're herePlease sign in to leave feedback Signed in as (Sign out) Close Close 1 vote 2 votes 3 votes Remove votes You have left! (?) (thinking…) 4 comments · dbForge Studio for SQL Server · Delete… · Admin → How important is this to you? Not at all You must login first! Important You must login first! Critical You must login first! We're glad you're herePlease sign in to leave feedback Signed in as (Sign out) Close Close An error occurred while saving the comment Alex Schubow commented · May 21, 2013 · Edit… · Delete… multiple database support here would be a huge plus as well. code like this runs in SSMS but not in devart Query Builder. UPDATE asmc.dbo.searchspringFeed SET asmc.dbo.searchspringFeed.[Qty Uncommitted] = SixBit_BT.dbo.Inventory.QtyUncommitted , asmc.dbo.searchspringFeed.[Fixed Price] = SixBit_BT.dbo.Inventory.FixedPrice FROM SixBit_BT.dbo.Inventory WHERE asmc.dbo.searchspringFeed.[Item ID] = SixBit_BT.dbo.Inventory.ItemID Save Submitting...
multiple database support here would be a huge plus as well. code like this runs in SSMS but not in devart Query Builder.
UPDATE asmc.dbo.searchspringFeed
SET asmc.dbo.searchspringFeed.[Qty Uncommitted] = SixBit_BT.dbo.Inventory.QtyUncommitted , asmc.dbo.searchspringFeed.[Fixed Price] = SixBit_BT.dbo.Inventory.FixedPrice
FROM SixBit_BT.dbo.Inventory
WHERE asmc.dbo.searchspringFeed.[Item ID] = SixBit_BT.dbo.Inventory.ItemID