Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008
    Posts
    16

    Unanswered: Insert text data into table

    Hi,

    I have a table ContentManagement with columns

    id --> int (identity)
    content ---> text

    I have to write an sql to insert a row in the above table.

    the data is in a file and all i know the location of the file..

    so I can't write a simple insert statement like the one below

    insert into ContentManagement (content)
    select "Inserting into text field"

    Can someone help in finding the way to insert data from the file into the text column.

    Regards
    Vishesh

  2. #2
    Join Date
    Dec 2007
    Location
    Chennai,India
    Posts
    12
    try bcp SyBooks Online

  3. #3
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Use the bcp utility

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •