Category: Microsoft SQL Server

How to add line numbers to T-SQL editor

Not sure why this feature doesn’t come out of the box. First, go to Tools > Options. In the... Read More

Sql Server bulk upload flat file

In every company I have been with, there has always been a legacy app (or sometimes new) that needs... Read More

SQL order of operation cheat sheet

Order Clause Description 1 FROM Choose your tables from where to get the data 2 JOIN Join matching data... Read More

How to search all objects in Microsoft SQL Server

I use this piece of SQL often. Just comment out the parts in the “WHERE” clause you don’t need.... Read More