concatenating string

Is there a way in SQL sever that can write the output as follow:

select events
  from mytable

original output

  • SQL: extract date from string
  • SQLException during executeBatch() when I'm handling BatchUpdateException
  • How to Connect to SQL Server using LINQ to SQL?
  • Truncate Table and UPDATE Statistics
  • Something like phpMyAdmin but for SQL Server?
  • How to change the table name in visual studio 2013 in design mode?
  • events
    --------
    123456
    894531
    985233
    829292
    920202
    392939
    299223
    

    desired output

    '123456', '894531','985233','829292','920202','392939','299223'
    

    select ” + CustomerID + ‘,’
    from dbo.Customers
    customerid
    ALFKI,
    ANATR,
    ANTON,
    AROUT,
    BERGS,

    Would like to see the result as
    customerid
    ‘ALFKI’,
    ‘ANATR’,
    ‘ANTON’,
    ‘AROUT’,
    ‘BERGS’,
    so on…

    2 Solutions collect form web for “concatenating string”

    SELECT
      STUFF(
        (SELECT
          ', ' + events
         FROM dbo.mytable
         FOR XML PATH('')
        ), 1, 1, '') As concatenated_string
    

    If you want the values enclosed in single quotes then edit the padding above.

    Concatenating Row Values in Transact-SQL discusses the various options you have, like recursive CTE, blackbox XML (like Mitch’ solution), CLR, cursors, recursive scalar UDFs etc etc, as well as some unreliable but fast approaches (SELECT with variable concatenation).

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.