Earlier I talked about dealing with the difficult forum user from the perspective of providing help. Now let us look at from the flip side of the coin. You are asking for help and you aren't getting what you want or need. The first thing you have...
2009-04-07
1,735 reads
Earlier I talked about dealing with the difficult forum user from the perspective of providing help. Now let us look...
2009-04-05
1,996 reads
I was looking through some of the active threads on SQLServerCentral.com tonight, and I ran across one with some code...
2009-04-04
3,643 reads
I was recently asked by a co-worker on my team at work what he should do to keep up with...
2009-03-31
1,887 reads
It has happened to us all at one time or another. We are trying to help someone on an online...
2009-03-25
1,554 reads
I'm sure that these routines are available in a variety of locations, this just adds one more place that people...
2009-03-25
39,535 reads
T-SQL calculations can get tricky at times, and since you often work with multiple rows, it's good to be exact in your data manipulation. New author Lynn Pettis brings us an article about calculating ages.
2009-03-13 (first published: 2008-06-30)
26,061 reads
Lynn Pettis gives us a look at a new way to solve a T-SQL problem.
2009-01-27
12,362 reads
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Hi to all We have situation at a client where someone is illegally changing...
Hi to all We have situation at a client where someone is illegally changing...
This week my BI Developer colleague proudly showed me a new Power BI report...
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers