Home Forums SQL Server 2005 SQL Server Express Help me for insert on query please RE: Help me for insert on query please

  • June 30, 2009 at 9:43 pm

    #1018126

    Nardig (6/30/2009)

    Yes the text file looks like this

    1,'John','Smith','Washington'

    2,'Nick','Smith','London'

    3,'blabla','blabla','blaa'

    .

    .

    .

    this text contains 1200 records

    Check out Books-Online (BOL) for "BULK INSERT". If your destination table has additional columns, you may need a format file (see "BCP" in BOL for how to create one). Since your field terminator isn't a tab, you'll need to specify that in the BULK INSERT command.

    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