Why Are Stored Procedures Too Hard?
Recently I was going through the buy or build process on a small segment of functionality needed for a project,...
2008-07-20
855 reads
Recently I was going through the buy or build process on a small segment of functionality needed for a project,...
2008-07-20
855 reads
A few months back I posted about our latest whiteboard and I thought I'd report back with an update. Initially...
2008-07-17
513 reads
Below is a list of various tools I use, some SQL related and some not. Follow the links to my...
2008-07-17
1,176 reads
Long time SSC participant Grant Fitchey has published a great book on reading/understanding execution plans. I finally had the chance...
2008-07-16
1,360 reads
The fourth annual Jacksonville Code Camp is set for August 23, 2008 and it looks like they are off to...
2008-07-15
467 reads
I ran across MentoringNet in a recent renewal flyer from ACM. I'm interesting in all things mentoring, so I went...
2008-07-14
1,004 reads
One of the things I use to identify how well a company is managed is by looking at how (well)...
2008-07-13
1,623 reads
My friend Steve Jones posted an article called What's an MVP on SSC that in turn led to a moderately...
2008-07-13
1,403 reads
SQLSaturday #5 in Olympia is progressing nicely. Greg, Russ, and team have locked in a venue and with registration just...
2008-07-11
408 reads
I did quite a bit of reading during a recent week off including two biographies. One was Boyd: The Fighter...
2008-07-10
391 reads
Every organization I talk to has the same problem dressed up in different clothes....
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item Using OPENJSON
Comments posted to this topic are about the item Data Modeling with dbt for...
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.key
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers