I want to insert bulk data without using txt file

Question

Post reply

I want to insert bulk data without using txt file

thummalalavanya

Valued Member

Points: 55
More actions
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.

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

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

LutzM SSC Guru Points: 107049 More actions · Answer 1

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]

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 2

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)

Paul White SSC Guru Points: 150467 More actions · Answer 3

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