|
Home > Archive > MS SQL Server Tools > March 2006 > How to type a multiline text in a column?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to type a multiline text in a column?
|
|
| Catalin NASTAC 2006-03-10, 9:25 am |
| 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
| |
| Erland Sommarskog 2006-03-11, 8:23 pm |
| 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
| |
| Catalin NASTAC 2006-03-13, 9:24 am |
| 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
>
| |
| Erland Sommarskog 2006-03-13, 8:24 pm |
| 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
|
|
|
|
|