Home Forums SQL Server 2005 SQL Server Newbies Inserting Comma Seperated Values in Sql Server 2005 RE: Inserting Comma Seperated Values in Sql Server 2005

  • May 29, 2008 at 7:08 am

    #821728

    Aswanth (5/29/2008)

    I'm Using Asp.Net with C#..

    i'm having One ListBox control in which I'm getting Data Dynamically.. I want to Insert the Selected data (or ALL DATA) from ListBox Control into My Table(Get_Data) in Sql Server Database.. Here I'm displaying NAMES(EMP_Names) in LISTBOX Control.. I want to Insert there ID(EMP_ID) values instead of NAMES..

    EVEN some times MULTIPLE SELECTIONS will also been done in LISTBOX Control.. I want to INSERT those MULTIPLE values in ONE COLUMN as COMMA SEPERATED VALUES (ex:1,2,3,4,5,6,7----)..

    How to do this..

    Please give me the code..

    Thank You..

    I think this article may help you out.

    http://www.sqlservercentral.com/articles/TSQL/62867/

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2