DanielE
4Penny.net
Points: 7900

6/6/2017 10:39:51 AM

SSMS - removing CRLFs

(sigh)

It's a real burden living with OCD <smiles>

(Aside: know what CDO is? It's OCD, alphabetized, they way it should be)

That being said, I really don't like inserts written like this, I find them hard to read and hard to maintain. So, you have to remove all the carriage returns in order to put them the way that I like. On a table with 200 fields, that's pretty onerous. 

It turns out that SSMS will do it with one 'replace'. Read on...

 

4Penny.net
Version: All
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3