Trigger Trivia Posted on SSC
A short article but interesting I think, with some good comments already. I think in general triggers are under used,...
2007-11-13
583 reads
A short article but interesting I think, with some good comments already. I think in general triggers are under used,...
2007-11-13
583 reads
We were lucky enough to have Joe come to Orlando to speak at SQLSaturday and we also talked him into...
2007-11-12
805 reads
One of the things I discuss in my Successful Technical Speaking class (it's a
free class, usually once a quarter)...
2007-11-12
611 reads
I'm just finishing up sending out thank you emails to the volunteers, speakers, and sponsors that helped make our first...
2007-11-12
611 reads
We (End to End Training) will be hosting our Celko on SQL seminar tomorrow (Nov 9th). It's not too late...
2007-11-07
686 reads
I happened to get an email asking me to vote for a product that was being featured in one of...
2007-11-07
657 reads
Replication usually involves data, but it can also include stored procedures as well. SQL Server expert trainer Andy Warren brings us a look at how you can ensure that your stored procedures move as well.
2007-11-05
7,654 reads
Most people 'set it and forget it' when it comes to replication, not realizing that changes to rows on the...
2007-11-05
410 reads
I was just reading the October 2007 issue and they have done what magazines are apt to do; redesign themselves...
2007-11-05
603 reads
Steve is the guy who wrote Code Complete (get rev 2 if you buy) which I consider to be required...
2007-11-05
478 reads
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Comments posted to this topic are about the item Creating JSON III
Comments posted to this topic are about the item Testing is Becoming More Important
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers