Posts by Denis de Souza Ontag • 26 points

• 1

  votes

  1

  answer

  141

  views

  A: Data to string conversion in SQL SERVER

  First to catch the current year use YEAR(GETDATE()); And to concatenate the year, which is an integer with a string, you need to convert the year to scan. The whole code would look like this: SELECT…

  sql

  answered 5 years, 8 months ago Denis de Souza Ontag 26