- Posted On 18 February 2014
- In Programming
SQL Online - Instant SQL Formatter - By Gudu Software
It's a fully featured sql formatter with many advanced output options and configurations.
It has facility to choose your own output format e.g HTML, C#, VB.NET and many more.
I found this very useful for developers as concanicate sql query in C# or VB.NET with string is such a tedious and boring job. But thanks to this tool, using this we can format our all sql code in any format we want that to in seconds and freely.
TSQL Code formatter - By sqlserverlearner
It is very simple TSQL formatter, just copy paste your sql in the textbox and click format. thats it in seconds you will get formatted sql with proper alignment. Its very simple and does not provide any other options as like other formatters.
Online SQL formatting tool
It is also simple sql formatter. Just need to copy paste sql text and click format and we get formatted sql text. We have choice to format sql text in different formats such as SQL,PHP and Phython etc. It also provides some other options to control the formatting which are as follows.
- Remove or keep comments
- Enable or disable syntax highligting
- Keywords casing
- Identifiers casing
- Language : SQL,PHP,Python
SQL Formatter - By SQL Complete - Devart
This is one of the best free online sql formatter tool powered by SQL Complete(Devart). Using this SQL code can be automatically formatted. The formatter can work either with available code or the code that is being typed. You don't need to pay that much attention to case, line breaks, whitespaces, indenting, wrapping, etc - the application will take care of them all for you.
It has several settings by which we can have total control on how our sql text needs to be format, obiviously its for adavanced formatting. Even if we use it as it is it can render nice formatted sql code which is easy to read, understand and debug.
PoorSql.com - By Tao Klerks
PoorSQL.com is an free online SQL formatting tool that uses the Poor Man's T-SQL Formatter library. This too has several configuration options and very easy to use.
Just need to provide SQL in "Input SQL", and we can get very well formatted SQL in "Foramtted SQL", also we can get "HTML Source" of the same if we want to show it in a html page, it provides styles too.(useful for bloggers :-))
It also provides plugin for Visual studio and SSMS.
I personally use PoorSQL,DpDriver and Devart's SQL-Format for formatting my SQL code and honestly it saves a lot time and also makes your code pretty and as per standard. :-)
Try each formatter and let me know which one is the best? If any other formatter you know feel free to share about it in comment section below.
Advanced Interview Questions and answers on C#.NET - Part 1
In this post we will discuss some advanced interview questions on C#.NET. which will help you to understand the type of questions asked in interviews for senior software engineer post.
What is Bootstrap(One of the best free HTML CSS framework for responsive web applications)
In this post I will try to answer the question 'What is Bootstrap?', which is one of the widely used opensource HTML and CSS framework or you can say front end framework. I will also introduce some useful sites for BootStrap.
What is modern.IE? New easy to use Testing tools for web developers from Microsoft
MICROSOFT introduces modern.IE, testing tools for web developers. Using these we can test our website across browsers, across devices. Has 90+ virtual machine's, Website Screenshot facility and compatibility scanner to optimize our website for best web experience.
Typewriter - Automatic TypeScript Template generation from C# classes in Visual Studio
Typewriter, an extension for visual studio that generates TypeScript files from C# code files using TypeScript templates. Convert your C# model classes to TypeScript automatically.
How to call click or any event only once in jQuery
Know how to execute an click event or any event only once for any element in jQuery. Perform action only once and even not required to unbind event.