Ensuring Each Client has a Full Set of Key-Value Pairs
In this piece, we find out about a business issue that can occur when using key value pairs in your database to describe information about other entities.
2018-07-10
593 reads
In this piece, we find out about a business issue that can occur when using key value pairs in your database to describe information about other entities.
2018-07-10
593 reads
Learn a quick method to find and remove duplicate records in your SQL Server tables.
2016-02-01
9,692 reads
Why should I care and why should the database enforce it? This article from Jamin VanderBerg gives some reasons why the database is the place to enforce rules that ensure integrity.
2010-08-30
3,969 reads
By kleegeek
On October 2nd and 3rd, I took part in an amazing event called AI...
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
Comments posted to this topic are about the item Comparing Images
Comments posted to this topic are about the item Time to Change Your Team
Comments posted to this topic are about the item A Tidy Database is a...
I am building an ETL process between these tables in SQL Server 2022 set to 160 compatibility level:
CREATE TABLE Image_Staging ( imageid INT NOT NULL CONSTRAINT Image_StagingPK PRIMARY KEY , imagestatus TINYINT , imagebinary IMAGE); GO CREATE TABLE Images ( imageid INT NOT NULL CONSTRAINT ImagesPK PRIMARY KEY , imagestatus TINYINT , imagemodified DATETIME , imagebinary IMAGE); GOI want to run this query to check if the images already loaded exist. This will help me decide if I need to insert or update an image. What happens with this query?
SELECT i.imageid FROM dbo.Image_Staging AS ist INNER JOIN dbo.Images AS i ON ist.imagebinary = i.imagebinary;See possible answers