Home » Interview Q&A » Remove blank lines in Sql Server Script

Remove blank lines in Sql Server Script

Difference between Nullable<> and ?
Find Blocking queries in Sql Server

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.


Hello friends, My self Dhruv Sheth, I have more than 6 years of Industrial experience as a Software Developer. In my career I got chance to work with asp.net, c#,Web API, JavaScript, JQuery, WPF, WCF , Windows Application, PostScript, vb.net, GhostScript etc. So I have decided to share my knowledge with everyone and finally I have come up with TechnoThirsty.

The content is copyrighted to technothirsty.com and may not be reproduced on other websites without permission from the owner.You may contact us using the information below.