Shane O’Neill compares table columns with T-SQL and Powershell:
That is not really going to work out for us…
So I’m not liking the look of this, and going through the results, it seems to me that these results are just not useful. This isn’t the computers fault – it’s done exactly what I’ve told it to do – but a more useful result would be a list of columns and then either a simple ‘Yes’, or a ‘No’.There’s syntax for this…
PIVOT…
This is helpful for normalizing a bunch of wide, related tables into a subclass/superclass pattern.