Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    5

    Question Unanswered: Is possible insert data (text) in a lvarchar datatype?

    I need to insert a resut of query (text) in another table with a lvarchar datatype... it is possible ? how?

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Depending on the version of your engine, lvarchar is a limited datatype.

    But of course this is possible.
    How do you want it? Do you want each result row to represent a new row in your other table?
    INSERT INTO tab1 (Select col1, col2 from tab2);

    If you want the full result of the query in one field - you should concatenate the resultset rows in one variable and then insert this variable in the new table
    rws

Posting Permissions

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