Objects tagged with sql


Posts

← Back to the Posts

[SOLVED] SQL Get Financial Year from Date

Published on February 07, 2018 at 12:21AM

This example will return the Financial Year for today's date. This can then be set to a variable to be used in another query

Using VS Code Extension MSSQL instead of Excel Power Query for Easy Database Querying

Published on February 07, 2018 at 12:01AM

Save a few minutes every time you want to query your database to check out some data by cutting Excel out of the equation.

Display a SQL Server Table Schema in PowerBI

Published on May 03, 2017 at 04:33AM

This was useful when building a subsequent M Query and needed to know all available table column, types and keys

Cheatsheet for Running SQL Against PostgreSQL from the Command Line

Published on April 06, 2017 at 02:41AM

I am using psql to interact with a PostgreSQL database from the command line and I don't know what I am doing :P

Screencasts

← Back to the Screenasts
There are no casts tagged with sql