SQL Server MVP Deep Dives, Volume 2
by Brad McGehee, Louis Davidson, Greg Low, Kimberly Tripp, Paul S. Randal, Kalen Delaney, Paul Nielsen
Chapter 21. Using regular expressions in SSMS
John Paul Cook
Regular expressions are known for their power and their cryptic nature. Many people avoid using them because the value isn’t perceived to be worth the cost of learning an arcane syntax. But there are a few high-value regular expression edits that have simple syntax. SQL Server Management Studio (SSMS) supports the use of regular expressions when editing queries. You can reap the benefit of regular expressions without having to master the tedious subtleties of advanced regular expression syntax. This chapter shows you how to efficiently use a few simple regular expressions within SSMS.
Eliminating blank lines
When you’re copying a query from an email message or web page, superfluous ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access