sql server database copy data and update 1 column : have existing table [dba.Text] and all the data in the table has to stay in there, the only thing i want is to copy all data with the year 2017 and change it to 2018. I tried to make it in excel to show what i mean
[How the table should look like][1]


  [1]: https://i.stack.imgur.com/lQIJv.png

Hope someone can lead me in the right direction :)