SQL Update Statement
The UPDATE statement is used to modify the existing records in a table. The syntax is as follows. […]
sql
Itzik Ben Gan’s Database
As a more complex and realistic example, let’s look at the database that Itzik Ben-Gan used in his […]
Excel Unique Function
The Excel UNIQUE function gives you all of the distinct values of a given range. All you need […]
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 […]