Excel Unique Function
The Excel UNIQUE function gives you all of the distinct values of a given range. All you need […]
sql
SQL Update one Table from Another
Are you working with an SQL database where you need to copy data from one table to another? […]
T-SQL Parsing To Get Frequency
This post is about determining just how many parts there are in a string that is delimited with […]
T-SQL Parsing Into Many Columns
This post is about working with one column in a SQL Server table that contains a comma-separated list […]
SQL Combining Two Tables
This post is about combining the data from two tables by adding columns, not rows. Here we think […]
Daily Thought Back-End
In this third post on this project we’ll look at the back-end, meaning the database. The database technology […]
SQLite Introduction
Wikipedia says: “SQLite is a relational database management system (RDBMS) contained in a C library. In contrast to […]
WPF ComboBox Colors with SQLite
This post is a follow-up to a previous post called WPF ComboBox Colors. In this project, I have […]
WPF SQLite Dapper List and Add People – 1
This series of posts shows us how to build a WPF project using SQLite and Dapper that allows […]
SQLite Database Introduction
SQLite is a relational database management system (RDBMS) contained in a C library that ends up being embedded […]
WPF Insert into SQL Server Table with Dapper
In this post we look at inserting a row of data into a SQL Server table from a […]
WPF Read a SQL Server Table into a DataGrid with ...
This post is about how to connect to a local SQL Server database and read a table from […]