change

Track object definition or table schema changes in any database. Batteries required: you need to create a few things to make it run.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(6)

You rated this post out of 5. Change rating

2010-05-14 (first published: 2009-06-24)

1,738 reads

Blogs

A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...

I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...

After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...

Hey all. I understand if this gets taken down due to the subject matter...

Comments posted to this topic are about the item Creating a JSON Document I

Comments posted to this topic are about the item Who is Irresponsible?

I want to create a JSON document that contains data from this table:

TeamID  TeamName  City          YearEstablished
1       Cowboys   Dallas        1960
2       Eagles  Philadelphia  1933

If I run this code, what is returned?

SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;