Home Forums SQL Server 2008 SQL Server 2008 - General I would like to insert from the clipboard text with line breaks in a "varchar" column. RE: I would like to insert from the clipboard text with line breaks in a "varchar" column.

  • in the object explorer on the left, expand your database till you see the table.

    right click on that table , and selecte the "Edit Top 200 rows;

    you can always change the SQL to get the whole table, but the grid that is presented is editable, so you can select a cell and paste into it, just like the old Enterpise Manager.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!