Skip to content

Twistedminds

  • Tech
  • About me

Подсчет количества записей в каждой из таблиц базы данных MSSQL

10/06/2010 by Stanislav
select substring(o.name, 1, 30) Table_Name ,i.rows Number_of_Rows
from sysobjects o
inner join sysindexes i
on (o.id = i.id)
where o.xtype = 'u'
and i.indid < 2
order by o.name

Categories Tech Tags mssql
Kerio Connect (Mail Server) и Status 2.1.5 delivered
postgresql tricks

Recent Posts

  • Beyond 802.11ac: 802.11ah HaLow
  • NBase-T
  • Интеграция D-Link Central WiFi Manager с Active Directory
  • Настройка D-Link Central WiFi Manager
  • D-Link Central WiFi Manager

Tags

802.11ac access gateway active directory apple catalyst ccnp route ccnp switch cisco citrix codepage cwm eigrp exchange 2010 gadget gmail google howto iOS ipad iPhone ipsec linux macos ME2 megafon microsoft netapp netscaler ontap ospf QoS tcam troubleshooting ubuntu vlan vmware vpn wifi windows Windows Server 2008R2 wireless xenapp баг графомания решаем проблемы
© 2025 Twistedminds • Built with GeneratePress