A SQL Server Patching Shortcut
This post on SQL Server patching illustrates a quick and simple way of safely extracting SQL Server installation files in advance of patching a SQL Server instance.
2016-04-05
4,781 reads
Ajmer Dhariwal
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCU BANDUNG TLP/WA 083800209966
Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
BCA KCP JOYOBOYO TLP/WA 083800209966
Jl. Joyoboyo No.34, Kemasan, Kec. Kota, Kota Kediri, Jawa Timur 64125
Alamat kantor resmi BCA KCP Sumatera telp:0817875533
WhatsApp:0817875533 Jl. Aiptu K.S. Tubun No.46, Pandau Hulu I, Kec. Medan Kota, Kota Medan,...
Question of the Day
Creating a JSON Document III
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