Post reply

I want to insert bulk data without using txt file

  • February 26, 2010 at 2:43 am

    #219450

    i want to insert bulk data in one field in a table without using txt file directly using insert statement .plese reply me.

  • February 26, 2010 at 3:02 am

    #1125455

    Hard to tell what you're trying to do...

    Please provide more details.

    Especially the following phrase is unclear (at least to me...): "without using txt file"


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • February 26, 2010 at 8:53 pm

    #1125928

    thummalalavanya (2/26/2010)

    i want to insert bulk data in one field in a table without using txt file directly using insert statement .plese reply me.

    OPENROWSET or text based linked server. It'll be a whole lot slower than using BULK INSERT with a properly setup format file, but it's what you ask for.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • February 26, 2010 at 11:54 pm

    #1126010

    thummalalavanya (2/26/2010)

    i want to insert bulk data in one field in a table without using txt file directly using insert statement .plese reply me.

    Do you mean: You want to copy lots of data from one column in a table to a different table? Is that it?

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply