title: SQL Server variable datetime with array
body: <p>Can we define a variable of type array in SQL Server?</p>
  <p>I have a table and this pk type is <code>datetime</code>.</p>
  <pre><code>CREATE TABLE [dbo].[tblTest]
  (
      [TestDate] [datetime] NOT NULL, -- this column is the primary key
      [UserId] [int] NOT NULL,
      [RotationType] [int] NOT NULL
  )
  </code></pre>
  <p>And I need a query to update <code>userId</code></p>
  <pre><code>UPDATE TABLE dbo.tblTest
  SET RotationType = 1
  WHERE TestDate IN (@testDates)
  </code></pre>
  <p>How can I declare this <code>@testDates</code> variable?</p>