Copy as WHERE clause
It would be useful to be able to copy a selection from the results grid which is pre-formatted as a WHERE clause in the same way "Copy as clause" IN works, e.g. copying a single value from ProductID column would produce WHERE ProductID = 5 and copying multiple values would produce WHERE ProductID in ( 5, 10, 15 ).
3
votes
Anonymous
shared this idea
-
Steven Knox
commented
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.