SQL Formatter for T-SQL
Your data never leaves your browserT-SQL includes TOP, NOLOCK hints, and square bracket identifiers.
Example
SELECT TOP 100 [u].[Name], (SELECT COUNT(*) FROM [Orders] o WITH (NOLOCK) WHERE o.[UserId] = u.[Id]) as Orders FROM [Users] [u] WHERE [u].[IsActive] = 1 ORDER BY Orders DESC;
Tips
- 1Select T-SQL dialect.
- 2GETDATE() and DATEADD.
- 3Format stored procs.
Frequently Asked Questions
T-SQL syntax?
TOP, NOLOCK, CROSS APPLY, square brackets.
TRY/CATCH?
Basic support.
CTEs?
Yes.