What's In A Blog? - BlogLock
Hi, ALL. Today's Blog is much ado about nothing? A totally free-form blog entry, with random thoughts on a passing scene.
Sometimes, it...
2011-07-01
697 reads
Hi, ALL. Today's Blog is much ado about nothing? A totally free-form blog entry, with random thoughts on a passing scene.
Sometimes, it...
2011-07-01
697 reads
I literally changed the topic of my blog today, (as I had my blogger open), since I had read some pretty...
2011-06-24
1,134 reads
If you're in a New York State of Mind (song by Billy Joel), then you'll like the triple play of...
2011-06-21
1,329 reads
When I heard Allen Kinsel’s (aka @sqlinsaneo|Twitter) Invitation to T-SQL Tuesday #19 – Disasters & Recovery, for some reason, I read it...
2011-06-14
1,586 reads
Well, ok. I'll jump on the bandwagon again.
Power has been restored to Mr. LaRock's Residence, just in time for meme Monday.
(And really,...
2011-06-06
1,155 reads
Sometimes, even if I’m not attending, some SQLSaturdays stand out to me, and catch my interest. I guess it’s a...
2011-06-03
1,006 reads
I have had the pleasure of knowing and communicating with Mr. Satya Shyam K. Jayanty, aka Satya/aka SQLMaster|twitterfor several years...
2011-06-02
2,231 reads
Here’s another awesome SQL event coming to New York City. (Keep reading for your discount below!) It’s already getting hot...
2011-05-31
2,353 reads
Hi, All. Just some thoughts on a passing scene. Didn't expect to blog today. Many projects in the queue, but...
2011-05-25
1,303 reads
Another great event coming to NYC this Thursday, May 26, 2011 @ 6PM! The NYC SQL Server User Group presents a...
2011-05-24
1,228 reads
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
This book was making its rounds on social media, and the concept seems interesting...
I declare @Where based on the input parameter in the stored procedure. Set @SQL...
Hi, hoping someone can help. We're in the process of migrating to a new...
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