Replace what? [modified]
-
REPLACE(dvel.Notes, ' ', ' ') T-SQL: Replaces newline with space.
Last modified: 4hrs 41mins after originally posted --
Pits fall into Chuck Norris.
-
REPLACE(dvel.Notes, ' ', ' ') T-SQL: Replaces newline with space.
Last modified: 4hrs 41mins after originally posted --
Pits fall into Chuck Norris.
What if the newline was also followed by a carriage return. Would you end up with a sequence of space, carriage return? That's pretty bizarre. :)
Chris Meech I am Canadian. [heard in a local bar] Donate to help Conquer Cancer[^]
-
What if the newline was also followed by a carriage return. Would you end up with a sequence of space, carriage return? That's pretty bizarre. :)
Chris Meech I am Canadian. [heard in a local bar] Donate to help Conquer Cancer[^]
It's replacing a 'literal' new line, so it would replace the CRLF combo with a space. The horror is not explicitly saying, DON'T REMOVE THIS LINE BREAK!
Pits fall into Chuck Norris.
-
It's replacing a 'literal' new line, so it would replace the CRLF combo with a space. The horror is not explicitly saying, DON'T REMOVE THIS LINE BREAK!
Pits fall into Chuck Norris.
-
It's replacing a 'literal' new line, so it would replace the CRLF combo with a space. The horror is not explicitly saying, DON'T REMOVE THIS LINE BREAK!
Pits fall into Chuck Norris.
Then the replace should happen before the data hits the database.
-
REPLACE(dvel.Notes, ' ', ' ') T-SQL: Replaces newline with space.
Last modified: 4hrs 41mins after originally posted --
Pits fall into Chuck Norris.
Uah looks terrible. :~
-
Then the replace should happen before the data hits the database.
Technically, it is. The query is to extract data destined for a target database that doesn't like newlines. It's an edge case, as other target databases are happy with the newlines.
Pits fall into Chuck Norris.
-
REPLACE(dvel.Notes, ' ', ' ') T-SQL: Replaces newline with space.
Last modified: 4hrs 41mins after originally posted --
Pits fall into Chuck Norris.
I don't see it, obviously the guy who wrote that used XVI32 and doesn't see anything wrong with it...
-Spacix All your skynet questions[^] belong to solved
-
I don't see it, obviously the guy who wrote that used XVI32 and doesn't see anything wrong with it...
-Spacix All your skynet questions[^] belong to solved
Spacix One wrote:
doesn't see anything wrong with it...
That's the horror. What don't you see? The ambiguity between a line wrap and a line break in a SQL statement?
Pits fall into Chuck Norris.
-
Spacix One wrote:
doesn't see anything wrong with it...
That's the horror. What don't you see? The ambiguity between a line wrap and a line break in a SQL statement?
Pits fall into Chuck Norris.
Well, I mean the guy who wrote it must have been using a Hex editor and the link break was just another two bytes to him, as he could only see "0D 0A" which looks normal, to him... :laugh: :D
-Spacix All your skynet questions[^] belong to solved
I dislike the black-and-white voting system on questions/answers. X|