The recent Emacs post made me think of a useful SQL trick I recently learned that I wanted to share. Emacs refers to different SQL engines as ‘products’, e.g. MySQL, SQLite, and so on. You can connect to an SQL database through Emacs but you have a call a different command based on the product. An easier [...]
25
May
SQL: Using IN / NOT IN Operators
Here is an explanation I recently shared with someone about how to use NOT IN to select a subset of data from a one-to-many relationship. It is a simple example that covers the basic use of NOT IN (and IN) operators in SQL. These operators can be fairly powerful for performing quick queries on complex [...]
15
Apr
Logistics & Inventory Management with Alutiiq
Alutiiq recently award Cyber Sprocket a 1-year teaming agreement, making this our 4th year of working with Alutiiq on developing, supporting, & maintaining their military logistics & inventory management application. We are very excited to be working with Alutiiq for another year. The upcoming year will bring some exciting new possibilities for follow on projects [...]
Talk To Me...
Enter your email below to sign up for the monthly Store Locator Plus newsletter. Click the Facebook icon to get almost-daily updates on what I'm working on now. The RSS feed icon will bring my bi-weekly blog posts to your feed reader.
