SQL SERVER：select 字元串拼接問題 - 一尾魚的專欄 - 博客頻道 - CSDN.NET

一、問題select UserID,LastName,FirstName,UserName From SYSUserUserID LastName FirstName UserName ----- 1 A B C 2 A1 ... SQL code DECLARE @STR VARCHAR(8000) SELECT @STR=ISNULL(@STR+',','')+USERNAME FROM TB SELECT @STR .

blog.csdn.net