I needed to merge two tables of data by matching primary key and then populating all other columns. The below TSQL code will accomplish that quickly and easily native within SQL. No need for remote client side PowerShell Dot Net. Hope you find this helpful. Cheers!
With custom SQL line of business databases it can be helpful to enumerate all tables and row counts for each. The below TSQL will create a new VIEW named “RowCounts” for that purpose. I’d suggest adding this to any custom SQL database for easy data quality checks and monitoring.