Count and display number of rows in all tables
This script can be used to display the number of rows of all the tables in a database.
2003-01-02
323 reads
Script to get tables which have primary key
There isn't a convenient sp or tool in sql server to find out all the tables in a database which have primary keys. This script can help you to list all the tables with primary keys.
2002-10-21
451 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