Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 symbole of enter in sql

Author  Topic 

lilinikco
Starting Member

28 Posts

Posted - 2010-09-27 : 01:07:05
hi all.
what's symbole or code of enter key in sql server?for replace?

lili@@

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-09-27 : 03:30:40
CHAR(13)

Vaibhav T

To walk FAST walk ALONE
To walk FAR walk TOGETHER
Go to Top of Page

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2010-09-27 : 04:28:02
but also note that the standard windows encoding for end of line is carriage return + Line Feed (or the other way around, I can never remember -- a hangover from typewriter days).

so it's CHAR(13)+CHAR(10)

CR+LF.....

Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
Go to Top of Page
   

- Advertisement -