title: SQL : Add unique ID and append a string
body: <p>I have the following for adding a unique ID to the field in SQL 2014 Mgmt Studio</p>
  
  <pre><code>ADD MY_ID INT IDENTITY (1,1) 
  </code></pre>
  
  <p>Is there a way where I can also append a fixed text next to the unique ID? </p>
  
  <p>Problem lies where the column is set to INT to begin with so even if I add two columns where one is set as the ID and the other a set string, I can't concat it without a transformation. </p>
  
  <p>In other words, can I do: </p>
  
  <pre><code>ADD MY_ID INT IDENTITY (1,1) + "Myfile.docx"
  </code></pre>
  
  <p>Thanks</p>