title: Store list of ids in a table cell - SQL Server
body: <p>I want to store list of ids (strings) in a SQL server table cell. These list of ids I'm getting while querying on another SQL server table.<br>
  These list of ids will be deserialized later into C# <code>List &lt;string&gt;</code> object.  </p>
  
  <p>I noticed that SQL server has some <a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/openjson-transact-sql" rel="nofollow noreferrer">OPENJSON</a> table-value function which can create JSON (in my case a JSON array) but I don't know how to use that for my purpose. </p>
  
  <p><strong>Update:</strong> OPENJSON is supported from SQL server 2016 but our is SQL server 2012. So OPENJSON is out of the question now.</p>
  
  <p>Any other approach is also fine as long as it storing the list in single cell and can be deserialized later directly to C# <code>List &lt;string&gt;</code> object.   </p>
  
  <hr>
  
  <p><em>Note: I don't want to use a separate table for storing ids. This is just for migrating data.</em></p>