Database

A collection of 2 posts

Database

Using a Rank Over a Partition When Working with Transactional SQL Tables

You will often encounter a transactional table in a SQL database.  This is a table that typically is only inserted into.  A good example is a bank account ledger where every transaction you

  • Jonathan E. Ross
    Jonathan E. Ross
3 min read
Code

Find any Column in a SQL Server Database

Let's say we're working with a Microsoft SQL Server and we have no idea what table or column stores a particular value. Trying to find a database column where we know what the

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
© 2023
Latest Posts Ghost