Concurrency Control in SQL Server
Learn a bit about concurrency problems in SQL Server, the issues they create, and the different isolation levels that help you solve them.
2020-05-12
42,734 reads
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 BALAI KOTA KARIMUN TLP/WA 081717899866
Jl. Teuku Umar No.19, Tj. Balai Karimun, Kec. Karimun, Kabupaten Karimun, Kepulauan Riau 29661
BCA Multifinance Cabang Kedoya Telpn/wa (08218171891)
Telpn/wa (08218171891) Citta Graha, Jl. Panjang, RT.5/RW.1, South Kedoya, Kebonjeruk, West Jakarta City, Jakarta...
BCA KCP KARIMUN TLP/WA 081717899866
Jl. Jenderal Ahmad Yani Barat No.A7-A8, Sungai Lakam, Kec. Karimun, Kabupaten Karimun, Kepulauan Riau...
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