Skip to content

Instantly share code, notes, and snippets.

@mkdizajn

mkdizajn/Display sql server columns from more tables with 'union all'

Last active December 20, 2015 01:09
Show Gist options
  • Save mkdizajn/6046721 to your computer and use it in GitHub Desktop.
Save mkdizajn/6046721 to your computer and use it in GitHub Desktop.
Download ZIP
Display sql server columns from more tables with 'union all'
Raw
Display sql server columns from more tables with 'union all'
(select COUNT(*) from temp.dbo.[tbl1]) union all
(select COUNT(*) from temp.dbo.[tbl2]) union all
(select COUNT(*) from temp.dbo.[tbl3]) union all
(select COUNT(*) from temp.dbo.[tbl4])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment