Copy and Paste Problem in Enterprise Manager

• Be Kim

  SSC Rookie

  Points: 36

  More actions

  August 27, 2004 at 8:06 pm

  #360849

  Hello

  I am trying to paste into a sql table from notepad.  I noticed that when I copy less than 100 characters into the cell it pastes fine but when I try to paste over 100 characters or so it won't paste.  My string has 2500 characters and I don't want to copy it 25 times.

  I set the Design for that column to be varchar 4000.  So I know it is not that problem.

  Then I tried to do this in Query Analzyer and I get the error that I can't copy more than 128 characters into cell at one time when use SET. 

   

  Is this a common problem with SQL 2000?  How do I get around it??

• rockmoose

  SSCarpal Tunnel

  Points: 4601

  More actions

  August 28, 2004 at 12:30 pm

  #520981

  SqlServer is a database not a text editor 🙂

  Have you read the manual ( BOL ) ?

  INSERT MyTable(... column ....)

  VALUES(.... 'my long string stuff' ....)

  or

  UPDATE MyTable SET

  column = 'my long string stuff'

  WHERE

  MyTableKey = myKeyValue

  /rockmoose

  
  You must unlearn what You have learnt