Remove blank lines in Sql Server Script
Problem: Let’s say we have a script in which there are blank lines in between two lines and you want to remove these blank lines from that script. Have look into below image,
As image we want to remove blank lines from script.
We need replace blank spaces, so we have to use Regular Expression as shown below
Let me know if you have any either way to achieve same.