2020-04-13
3 reads
2020-04-13
3 reads
In this article, we will learn how to enable the Azure AD multi-factor Authentication via Azure Portal. In previous article, we learnt how to set up Azure AD and...
2019-03-27
26 reads
Microsoft Azure Active Directory (AD) is a cloud based service to handle the identity and access management. It has the...
2019-03-21
517 reads
In this article, we will learn how to replicate the data to any Azure region globally. Global Distribution Azure Cosmos...
2018-07-02
360 reads
Hello Friends, Please find the link of new post of about Introduction to Cosmos DB and how to create the...
2018-06-04
295 reads
Hello friends, Please check the below link for my new post on Microsoft Azure Mobile App. https://social.technet.microsoft.com/wiki/contents/articles/51525.microsoft-azure-mobile-app-is-available-now.aspx
2018-05-14
680 reads
Hello friends, Please check the below link of my new article on TRIM() function in SQL Server 2017 – https://social.technet.microsoft.com/wiki/contents/articles/51047.introduction-to-trim-function-in-sql-server-2017.aspx
2018-01-08
372 reads
Hello Friends, Wish you all a very Happy New Year 2018. Please find the link of my first article of...
2018-01-01
454 reads
Hello friends, Please find the link for my new article at below url – https://social.technet.microsoft.com/wiki/contents/articles/44327.sql-server-concat-ws-function-in-sql-server-2017.aspx Regards Kapil
2017-10-26
530 reads
Hello friends, Please find the full article at this link – https://social.technet.microsoft.com/wiki/contents/articles/40666.sql-server-identity-cache-feature-in-sql-server-2017.aspx
2017-10-11
458 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