So… Copy as IN Clause. Love it, but let’s improve it. Let’s say we have the following output…

ProductID ProductDesc
1 SQL Prompt
2 SQL Search
3 SQL Compare

If we use Copy as IN Clause on the ProductID column, we get:

IN
(
1,
2,
3
)

Which super…. However those IDs mean nothing to me in 6 months time when I’m now having to modify my code. What would be awesome, is if I can select both ProductID and ProductDesc, then hit Copy as IN Clause, and get the following output:

IN
(
1, -- SQL Prompt
2, -- SQL Search
3 -- SQL Compare
)

Now I can see what those IDs relate to.