Re: How do you insert a carriage return in Management Studio?

Nick Gilbert (nickg@xxxxxxxxxxxxxxxx) writes:
This is really winding me up. How on earth do you type a carriage return into a field from the "open table" view in SQL Server Management Studio? I think I've tried everything - including copying and pasting something with a carriage return in it. It seems to strip all text pasted in after the first carriage return. The field is NTEXT, but that probably doesn't matter.

The answer is that you start to learn to use INSERT statements to enter
your data. Open Table does not permit you to insert line break.

Obviously I know how to use INSERT and UPDATE statements, but sometimes you just quickly want to change a value or two and having to write an insert or update query just to do something this simple is a hassle. You could do this easily in SQL 2000 so I don't see why they've opted to remove this possibility in SQL 2005. Why not just let CTRL-Enter insert a CR like you can in most other databases and programs? GRRR.

By the way, SQL 2005 offers a new data type nvarchar(MAX) which just
like ntext permits unlimited amount of text, but that does not have
all the quirks and limitations of ntext. Strongly recommended.

Thanks for pointing this out... Sounds very useful!

Nick...
.

Relevant Pages

  • Re: Recommendation for a datatype for replication
    ... I've not had any problems using ntext in replication scenarios. ... issues with an ntext column? ... someday when you move from SQL CE to SQL Mobile, ... If the length of the data is 255 characters or less; SQL Server CE ...
    (microsoft.public.sqlserver.ce)
  • RE: ntext column with 256 chars does not ger synch
    ... length greater than 255 characters. ... and a primary key cannot be created on an ntext column. ... I have also a pocket pc with SQL CE 2.0 with the same ... Everytime I sync and the data (SQL ...
    (microsoft.public.pocketpc.developer)
  • Re: Access managment in SQL
    ... > I have just imported my old access database into my new ... then ntext or text is what you want. ... The ncharrequires SQL Server reserve 4000 bytes for each row. ...
    (microsoft.public.sqlserver.clients)
  • Re: ntext problem
    ... tables has a ntext data column. ... issue may have nothing to do with the ntext column at all. ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.programming)
  • EXCEPTION_ACCESS_VIOLATION using ntext
    ... I get the following error when i execute the SQL below. ... It works if the sp parameter is text rather than ntext or if the update uses ... @source int, ...
    (microsoft.public.sqlserver.server)
Loading