We can do the same thing in a Sql Server Query also

DECLARE @fruitNames VARCHAR(8000) 
SELECT @fruitNames = COALESCE(@fruitNames + ', ', '') + FruitName FROM Fruits
SELECT FruitNames = @fruitNames