SQL Server STUFF
The STUFF function in SQL Server is one of those little gems that is very under-used but when needed can be a real handy utility – at least that’s...
2022-01-10
15 reads
The STUFF function in SQL Server is one of those little gems that is very under-used but when needed can be a real handy utility – at least that’s...
2022-01-10
15 reads
I blogged the other about have some issues translating Oracle date formats to SQL Server date data types I find the way SQL Server handles dates with a defined...
2021-12-06
3 reads
I was doing some conversion of Oracle code (PL/SQL) to SQL Server code (T-SQL) – which had some quirks. I just thought that I’d share a quick tip that...
2021-12-02
4 reads
G’day, I was asked recently what a modern data warehouse is – and that’s a vey thought provoking question. First, there’s the tag “Modern” – I think what’s modern...
2020-12-14
12 reads
OPENJSON is pretty central to manipulating JSON documents in T-SQL. As we’ve seen, we can use a default schema that will return metadata about the JSON document or we...
2020-06-24 (first published: 2020-06-09)
6,557 reads
OPENJSON is pretty central to manipulating JSON documents in T-SQL. As we’ve seen, we can use a default schema that will return metadata about the JSON document or we...
2020-06-09
5 reads
Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some other things too. It’s all pretty fundamental to writing...
2020-06-08
274 reads
Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some other things too. It’s all pretty fundamental to writing...
2020-06-08
4 reads
We’ve looked at getting pulling data from a JSON document into relational table format using an explicit schema that was defined in the WITH clause of the OPENJSON table...
2020-06-07
14 reads
We’ve looked at getting pulling data from a JSON document into relational table format using an explicit schema that was defined in the WITH clause of the OPENJSON table...
2020-06-07
1 reads
I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which...
The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial...
Introduction Do you remember the effort of tidying up your BI and reporting systems,...
Comments posted to this topic are about the item Moving On After a Technology...
Comments posted to this topic are about the item Configuring Maintenance Plans in SQL...
Comments posted to this topic are about the item Counting Bits III
What is the output of this code in SQL Server 2022?
select bit_count(0xEF)See possible answers