SQL Server 2008 R2 August CTP – Utility Control Point (UTP)
I finally carved out some time in my day to try and get the August CTP of SQL Server 2008...
2009-09-18
1,359 reads
I finally carved out some time in my day to try and get the August CTP of SQL Server 2008...
2009-09-18
1,359 reads
Always On: SQL Server High Availabilty
Just wanted to tell you all about a fantastic Webinar on SQL Server High Availability,...
2009-09-18
941 reads
In the next few months, I’ll be giving a couple of talks on SQL Server business intelligence. For October, I...
2009-09-18
827 reads
Last week I posted Part 1 and Steve Jones gave some grief about not posting some pictures (rightfully so) of...
2009-09-17
835 reads
I noticed that the keys on my laptop were pretty dirty the other day. The heavily used ones have a...
2009-09-17
800 reads
Your servers are only as fast as the slowest part, hard drives.To feed other parts of the system we have...
2009-09-17
3,332 reads
Business Intelligence Developers Studio (aka BIDS) for Microsoft SQL Server 2005 Reporting Services makes creating engaging and dynamic reports nearly...
2009-09-17
1,224 reads
A colleague pointed out a site that collects a lot of job posting data and exposes graphs - so I've taken...
2009-09-17
4,229 reads
A minor annoyance of mine for a long time has been how SSMS will sometimes prompt you to connect to...
2009-09-17
379 reads
Bet you’re ready to disagree, right? I’ve had this on my list to write about for a while. One trend...
2009-09-17
1,355 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...
Kamagra Oral Jelly 100 mg is a medication used to treat erectile dysfunction (ED)....
Comments posted to this topic are about the item Using OPENJSON
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