Remove Unnessasary Blank lines

Remove blank lines in Sql Server Script

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,

Remove Unnessasary Blank lines

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

Regular_expression Sql Server

 

Let me know if you have any either way to achieve same.