SQL Update From Another Table
We want to add a new column to our Orders table and put the product name into that […]
sql
SQL Add Column
What is the SQL statement that adds a column to an existing table? The SQL statement is the […]
SQL Update Statement
The UPDATE statement is used to modify the existing records in a table. The syntax is as follows. […]
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 […]