GIN-List

GIN-List Example Usage

GIN-List Example Usage

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. 

Installation Instructions

  1. To install unzip GenerateInListAddin.zip
  2. Batch file is intended for SSMS 2014 and its default installation location. Run "GenerateInList Install.bat" as Administrator

Alternative Installation Instructions (Batch File steps)

  1. Copy GenerateInList.AddIn to "%APPDATA%\Microsoft\MSEnvShared\Addins"
  2. 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.