T-SQL Decommenter Part II

Demonstration of the T-SQL Decommenter removing comments from a sample T-SQL batch.

T-SQL Decommenter Part I

Introduction to a T-SQL query that remove comments from T-SQL code

Mixed Joins

Finding the Percentage

COLUMNPROPERTY in SQL Server 2016/2017

Conditionally Order By Different Column

Order records based on a different column depending on which absolute value is greater.

TRY_PARSE

Introducing the PARSE function, brought to us in SQL Server 2012.

T-SQL to compress (shorten) IPv6 address

Didn't find anything, so hope this will help someone with similar need.

Note I did a similar set-based version, and unless the input is more towards non-zeros in all eight 2-byte fields, the set-based performs not as well

Index on a computed column

Displaying Hierarchical Data

Producing hierarchies from SQL tables can necessitate joining a table to itself. This article will explain how you can do this.