Generate in list add-in for ssms
This Add-In was created to facilitate writing SQL queries where one has to specify a list of IDs in an IN list. The list of values on which you filter on might be coming from a SQL grid, or an Excel file; in either case it marks each of the values as strings, adds comma separators and the necessary parentheses.
Confirmed working on SSMS 2008 R2, SSMS 2012 & SSMS 2014.
ZIP Installation Instructions
- To install unzip GenerateInListAddin.zip
- Batch file is intended for SSMS 2014 and its default installation location. Run "GenerateInList Install.bat" as Administrator
Alternative ZIP Installation Instructions (Batch File steps)
- Copy GenerateInList.AddIn to "%APPDATA%\Microsoft\MSEnvShared\Addins"
- Copy GenerateInListAddIn.dll to "C:\Program Files (x86)\Microsoft SQL Server\???\Tools\Binn\ManagementStudio" replacing ??? with the appropriate directory for your version of SSMS.
Note: After performing the steps above ensure that you close out of all instances of SSMS and restart. The Add-In option should now appear in the Tools menu associated with the key combination Ctrl-F12.