sql - 如何从 SQL Server 中的字符串中删除最后一个符号。如果它是一个循环

Question

我有一个疑问

WHILE @@fetch_status = 0 
BEGIN   
   SET @message =' ,' + CASE WHEN @year < 10 THEN 'socyr0' ELSE 'socyr' END + CAST(@year AS varchar) + ' as '+ CAST(@sql AS varchar) + ','  
   PRINT @message   
   FETCH NEXT FROM SocioCursor INTO @year
   SET @sql = @sql + 1 
END

结果是一些字符串，例如

socyr08 as 2006,  
socyr09 as 2007,  
socyr10 as 2008,  
socyr11 as 2009,  
socyr12 as 2010,  

我应该改变什么才能得到

socyr08 as 2006,  
socyr09 as 2007,  
socyr10 as 2008,  
socyr11 as 2009,  
socyr12 as 2010  

Answer 1

我不确定您是否希望它们出现在单行文本中。我认为你可以像下面这样没有光标来做到这一点。

请根据需要调整变量长度和正确的函数，如果需要，请删除char(13)单行无换行符。

Sql-Fiddle Demo

declare @sql int = 2006, @message varchar(500)

select @message = isnull(@message + ',' + char(13), '') + 
                  'socyr' + right(100 + year, 2) + ' as ' + 
                  convert(varchar(4), @sql), 
                  @sql = @sql +1
from T

select @message


| COLUMN_0     |
----------------
socyr01 as 2006,
socyr02 as 2007,
socyr09 as 2008,
socyr10 as 2009,
socyr11 as 2010