sql
How to View Bit Values in MySQL Query Browser
I stumbled across this useful tidbit the other day in the MySQL Forums. I’ve always been frustrated that bit data type values fail to appear in MySQL Query Browser. Instead, it simply displays a ‘b’ regardless of the actual value.
I looked through all of the options but couldn’t find a setting related to the [...]
How to Create Delimited Lists of Related Data in Your MS SQL Queries
Describes a technique for including comma-delimited lists from related tables as a column in your SQL result set.
Retrieving Records with Max Values using TOP
I know I know, it’s a horrible title. If anyone has a better suggestion please let me know!
Here’s what I’m talking about:
I have two tables; the first table contains unique records describing games and the second contains game ids, scores, and user ids. Game id is joining the first table to the second [...]
