← Customer Feedback for Redgate Settings and activity 1 result found Copy as WHERE clause 4 votes Vote Vote Vote We're glad you're herePlease sign in to leave feedback Signed in as (Sign out) Close Close Vote We’ll send you updates on this idea 2 comments · SQL Prompt » User interface · 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 Steven Knox commented · May 8, 2023 · Edit… · Delete… Additionally, selecting multiple columns in a single row (e.g, City and State) could produce WHERE City = 'Anytown' AND State = 'NY' I would suggest selecting both multiple rows and columns should disable Copy as Where as this creates some ambiguity and complex SQL. Save Submitting... Steven Knox supported this idea · May 8, 2023
Steven Knox
supported this idea
·
Steven Knox
supported this idea
·
Additionally, selecting multiple columns in a single row (e.g, City and State) could produce WHERE City = 'Anytown' AND State = 'NY'
I would suggest selecting both multiple rows and columns should disable Copy as Where as this creates some ambiguity and complex SQL.