Check Syntax on a Database
This script finds the first error on all Sprocs, Functions, Triggers and Views in a database. Works in SQL Server 2005 and 2008
2009-04-21 (first published: 2009-03-26)
900 reads
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
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...
Forums
BCA KCP Kenten Hub.0851•8812•0691
BCA KCP Kenten Hub.0851•8812•0691 Jl. MP. Mangkunegara Jl. Villa Kenten No.20-21, 8 Ilir, Kec....
BCA KCP Kramat Jati Hubungi:0851•8812•0691
BCA KCP Kramat Jati Hub.0851•8812•0691 Jl. Raya Bogor No.19, RT.1/RW.4, Wil, Kec. Kramat jati,...
BCA KCP Gajah Mada Tegal Telp/wa 085169998765
Telp/wa 085169998765 Jl. Gajah Mada. 41A & 41B, Mintaragen, Kec. Tegal Tim., Kota Tegal,...
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