2017-05-02
1,375 reads
T-SQL
OUTPUT Clause Basics (For Inserts and Deletes)
When INSERTING or DELETING rows from a table, the OUTPUT clause can be used to return a dataset containing the changes made. Mat Richardson explains how.
2019-12-27 (first published: 2017-05-02)
9,905 reads
2017-04-24
1,122 reads
Should I Type * or 1 With the EXISTS Logical Operator
In my project I see that people writes different things with EXISTS logical operator (EXISTS (SELECT StarOrOne FROM...)). They are "*", "1" and even "TOP 1 1" or "TOP 1 *". The aim of this article to give a good explanation which option is the best.
2020-01-24 (first published: 2017-04-24)
14,887 reads
2017-04-21
1,249 reads
2017-04-14
1,202 reads
Nuance of datetime data type in SQL Server
One of the most confusing data types in SQL Server is the datetime datatype.
2017-04-13
2,354 reads
2017-04-06
1,473 reads
2017-03-23
1,100 reads
Adding Years, Months and Days
Adding Years, Months and Days to Years, Months and Days, with Bonus UK Public Holiday calculation.
2017-03-14
3,217 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 KCU RAWAMANGUN Hub.0851•8812•0691
BCA KCU RAWAMANGUN Hub.0851•8812•0691 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta...
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
BCA KCP RADEN SALEH TLP/WA 083800119009
Jl. Raden Saleh No. 13, 15, 17A, Daerah Khusus Ibukota Jakarta 10430
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