I have a statement such as SELECT IDENTITY (int, 1, 1) AS RowID INTO ... that works just fine. Now I want to prepend a literal to it.
I thought that SELECT 'XYZ' + IDENTITY (int, 1, 1) AS RowID INTO ... would work but I get a syntax error. I tried using CAST and CONVERT around the IDENTITY statement but that too fails.
Ideas?
I thought that SELECT 'XYZ' + IDENTITY (int, 1, 1) AS RowID INTO ... would work but I get a syntax error. I tried using CAST and CONVERT around the IDENTITY statement but that too fails.
Ideas?