Wednesday, July 28, 2010
Regular Expressions in SSMS
In one of my posts ,
I gave a tip how to replace
Enters in MS Word. We can
do this and a lot more in
SSMS itself by using
By pressing Ctrl+H in the SSMS you will open the "Find and Replace".
Choose in the Use option "Regular expressions".
Now, if you do not know how to use the regular expressions,
SSMS provides you a basic help, press the button with
So, for example you want to replace Enters(new line seperators)
to commas(","), then enter "\n" in Find What text box and "," in
Replace with text box.
You can find more info here.
Labels: SSMS Tip