Copy As IN Clause
Published 29 October 2019
From a results grid in SSMS, highlight one column of values, right-click on the grid, and use SQL Prompt's Copy as IN clause tool to reformat the values as an IN clause, which you can then use to, for example, query another table, comparing the rows for differences.