SQL Scripts: Record Counts
As I’m populating a sample set of data in a SQL Server project, I needed a quick way of identifying what tables I had missed. Here’s what I came up with (but a much faster way is noted below using the sys tables). — Identifies zero record count tablesdeclare @vtb varchar(200)declare @vsc varchar(200) declare x … Read more