Re: How do you insert a carriage return in Management Studio?
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 28 Jun 2006 22:23:27 +0000 (UTC)
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.
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.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- How do you insert a carriage return in Management Studio?
- From: Nick Gilbert
- How do you insert a carriage return in Management Studio?
- Prev by Date: Re: Foreign Key Relationships Management Form
- Next by Date: RE: Error 0x80041010 WinMgmt when launching SQL SERVER MANAGEMENT STUD
- Previous by thread: How do you insert a carriage return in Management Studio?
- Next by thread: Re: Foreign Key Relationships Management Form
- Index(es):
Relevant Pages
|
