How to type a multiline text in a column?

I can't find how to enter a multiline text in a row...
I use SQL Server Management Studio, Table >> Open Table. I have a text
column (varchar) and I want to type some text containing CRLF. I alos tried
to copy / paste from notepad a multiline, but it insert only the first line.
Please help!
Thanks

Catalin NASTAC  (CatalinNASTAC@discu
ssions.microsoft.com)  writes:
> I can't find how to enter a multiline text in a row... I use SQL Server
> Management Studio, Table >> Open Table. I have a text column (varchar)
> and I want to type some text containing CRLF. I alos tried to copy /
> paste from notepad a multiline, but it insert only the first line.

Do it from a query window:

INSERT tbl(a, b, c)
VALUES (1, 2, 'This text
has a newline it')




--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Thanks, but should I understand that I have no way to enter it by SQLSMS?
Like CTRL+Enter in EM 2000? It was "discontinued"?

"Erland Sommarskog" wrote:

> Catalin NASTAC  (CatalinNASTAC@discu
ssions.microsoft.com) writes: 
>
> Do it from a query window:
>
> INSERT tbl(a, b, c)
>    VALUES (1, 2, 'This text
> has a newline it')
>
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>

Catalin NASTAC  (CatalinNASTAC@discu
ssions.microsoft.com)  writes:
> Thanks, but should I understand that I have no way to enter it by SQLSMS?
> Like CTRL+Enter in EM 2000? It was "discontinued"?

It may be that you don't have that possibility. Plenty of features were
dropped from EM and QA when Mgmt Studio was created. This may be one of
them.

Personally, I don't use Open Table, so I don't know. I find that writing
SQL statements to insert data is more productive in the long run.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx