SSC Editorial: Access Disdain
Contrary to the title (by design), Access Disdain is about not automatically hating Access (or it’s users). Clearly Access has...
2014-07-17
624 reads
Contrary to the title (by design), Access Disdain is about not automatically hating Access (or it’s users). Clearly Access has...
2014-07-17
624 reads
Here’s the latest update on our registrations. We’re still ahead of all our previous events, that’s good, and we’re 2...
2014-07-16
574 reads
I did an online presentation about PCI and Credit Card Security for BSSUG last night and it went pretty well,...
2014-07-16
678 reads
Had our second planning meeting, still trying to complete the email template and realized we had not clearly defined two...
2014-07-15
640 reads
Many of you are interested in learning more about SQL Server and improving your career. However can you extend that to your colleagues? Can you convince them to become better IT professionals? Andy Warren has some thoughts.
2014-07-14
232 reads
Most PASS Chapter meetings are supported by sponsors who either provide money which is often used for food and drink,...
2014-07-14
735 reads
If you work with colleagues that aren’t as interested in growing and learning as you are, I hope you’ll read...
2014-07-14
637 reads
Probably you’ve heard about it already, but a quick post just in case – you can download a 100 or so...
2014-07-11
997 reads
Rained as I left (early) for the meeting, confirming again why I always leave early – stuff happens (in Orlando, rain...
2014-07-11
671 reads
Last week ended up better than expected when PASS decided to release feedback to speakers (selected or not) who requested...
2014-07-09
701 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