title: What datatype should be used to store an array in the SQL Server
body: <p>I am trying to create a table in my database using Visual Studio.
  I've got a table for my <strong>Products</strong> (like in online shop) and then I have a table for <strong>Orders</strong>, which should store all products that user has ordered. The problem is that I am not sure which datatype I should use when designing the database to store an array of products in my <strong>Orders</strong> table. <a href="https://i.stack.imgur.com/dbEtZ.png" rel="nofollow noreferrer">This is what the <strong>Orders</strong> table should look like</a></p>
  
  <p><a href="https://i.stack.imgur.com/dbEtZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dbEtZ.png" alt=""></a></p>