👩💻 Join our community of thousands of amazing developers!
I’m looking into creating some functions to make it easier to carry out quality checks on our database tables. I’m using SQL Server, where tables are referred to in a [database].[schema].[tablename] format, although you can forgo some of this by using the USE statement - USE my_data_base GO Let’s say you want to run a simple query: SELECT columns, you, want, to, select FROM yourschema.yourtablename; Easy enough, but you might want to run it over several tables, and vary the columns. You could...