Technical Article

Function to Format Select Queries to Columns

This function will strip all extra spaces, CRLFs and tabs from a SELECT statement, from the SELECT keyword to the End of the Order By clause, then reformat the statement to put all keywords at the left margin and subordinate clauses indented by ONE Tab.  There is an example of a SELECT statement that came […]

You rated this post out of 5. Change rating

2003-12-07

149 reads

Blogs

TryHackMe Advent of Cyber

By

I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...

You should be running on SQL Server 2022

By

It’s me again with my apparently semi-annual blog post. This time we’re going to...

Removing a PowerShell Array Element–#SQLNewBlogger

By

I saw an article on this and realized I had no idea how to...

Read the latest Blogs

Forums

Asking for your feedback on a PHP code security scanner in beta

By Kevbrock12

Hey! Kev is here to invite you to an exciting experience. Our team, full...

WHY Follow a LEFT OUTER JOIN with another LEFT OUTER JOIN

By YSLGuru

NOTE: The Topic Title probably isn't very good but I wasn't sure how to...

Replication Monitoring with Always On Availability Group

By sqlpops

Hey Folks, So I have SQL Transactional Replication set up on a database that's...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers