SQL Bits – Europe’s largest SQL Conference
4th 7th March
ExCeL Centre in London, England
SQLBits have announced their dates for 2015.
I have been three times and...
2014-12-12
1,396 reads
4th 7th March
ExCeL Centre in London, England
SQLBits have announced their dates for 2015.
I have been three times and...
2014-12-12
1,396 reads
Readers of my blog would be pleased to know that I have teamed up with Packt Publishing and we are...
2014-06-12
720 reads
That’s folks you heard it here first. Since the end of 2013 through to April this year I have been...
2014-05-14 (first published: 2014-05-07)
2,236 reads
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on...
2014-05-05 (first published: 2014-04-24)
24,961 reads
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-28 (first published: 2014-04-21)
1,956 reads
We can create a database simply by typing in the command createdatabase DB1
We don’t have to provide any other...
2014-04-25 (first published: 2014-04-16)
2,363 reads
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-23
1,041 reads
I have just returned from a trip to Washington DC where I was delivering course 2105 – SQL Server 2012 DBA...
2014-04-22
837 reads
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write...
2014-04-17
826 reads
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-14
2,771 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