If you copy and paste T-SQL code around frequent enough, I am sure you would have seen the double spacing issue.
select name from sys.databases where database_id = 1 order by name
The quickest way to remove double spacing is by using the “Find and Replace” function found in SQL Server Management Studio (SSMS):
- Find and Replace: Ctrl+H
- Find what: \n\n
- Replace with: \n
- Find options: Use Regular expressions
- Replace All: Ctrl+A
Bob is your uncle.