اتصال مقادیر یک ستون جدول بدون استفاده از متغیر

CREATE TABLE #test    
(      id TINYINT IDENTITY ,      nam NVARCHAR(100)    );
GO
INSERT  INTO #test
        ( nam )
VALUES  ( N'keteb' ),
        ( N'medad' ),
        ( N'mashin' )

         
SELECT     * 
FROM     #test
ORDER BY nam

      
SELECT  STUFF(
(SELECT ',' + nam
 FROM   #test
 ORDER BY nam
        FOR   XML PATH('') ,
                  TYPE
).value('.', 'varchar(max)'), 1, 1, '')   AS Concatenate_nam  

/*

output

*/

Concatenate_nam
keteb,mashin,medad

1.

http://stackoverflow.com/questions/194852/concatenate-many-rows-into-a-single-text-string

2.

http://www.sqlmatters.com/Articles/Converting%20row%20values%20in%20a%20table%20to%20a%20single%20concatenated%20string.aspx

3.

http://sqlperformance.com/2014/08/t-sql-queries/sql-server-grouped-concatenation

4.

https://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/