title: The argument 1 of the XML data type method "value" must be a string literal
body: <p>How to change my T-SQL query so that this error doesn't occur:</p>
  
  <blockquote>
    <p>'The argument 1 of the XML data type method "value" must be a string
    literal.'</p>
  </blockquote>
  
  <p>T-SQL code:</p>
  
  <pre><code>Declare @Count Int = 1
  While(@count &lt;= @j)
  Begin
  insert into mytable
  ([Word])
  Select ([XmlColumn].value(N'word['+Cast(@Count as nvarchar(2))+']/@Entry','nvarchar(max)'))
      from OtherTable WHERE ID=2
  </code></pre>