2016-03-31
1,712 reads
T-SQL
2016-03-29
1,640 reads
Insert Stored Procedure Results Into New Table Without Using OPENQUERY
OPENQUERY arrives with a lot of baggage. Try this alternative technique to inserting stored procedure results into a new table.
2017-09-22 (first published: 2016-03-22)
15,903 reads
2016-03-15
1,569 reads
2016-03-11
1,736 reads
Find a String in a String in SQL Server
Learn how you can find data in a string and extract it, no matter where it's located.
2016-03-10
41,039 reads
2016-03-07
1,867 reads
2016-02-25
1,264 reads
2016-02-22
1,589 reads
2016-02-19
1,819 reads
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
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...
Forums
BCA KCU THAMRIN Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta...
BCA KCP Dewi Sartika Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Dewi Sartika No.189, RT.1/RW.5, Wil, Kec. Kramat jati, Kota Jakarta Timur, Daerah...
BCA KCP Cipondoh Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. KH. Hasyim Ashari Km. 1,5 Blok C-D, RT.002/RW.003, Poris Plawad Indah, Kec....
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