Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
Someone posted this as a question and I thought it was worth noting. I use SQL Prompt for formatting, and never worry if there are tabs in code, but I know there are people without this amazing tool.
I added some tabs to a script and want to replace them.
I hit CTRL+H for the search and replace toolbar. The tab character is represented by a \t in a regular expression. I enter that, and then enter 4 spaces in the replace text box. I do need to click the “Use Regular Expressions” button, which is the one my arrow is on in the image below. It’s a little box with an asterisk in it
When I do that, tabs are highlighted in SSMS.
If I click “replace all”, I see 4 replacements, and if I check, the tabs are gone and spaces live.
This is a quick post, an example of what you can do to show you’re building better work habits and learning about your tools.