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
Post navigation
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 citrix WI cwm easy vpn eigrp esxi exchange 2010 gmail google howto iOS ipad iPhone ipsec linux macos megafon microsoft netapp netscaler ontap ospf QoS site-to-site tcam troubleshooting vlan vmware vpn wifi windows Windows Server 2008R2 wireless xenapp баг графомания решаем проблемы
© 2022 Twistedminds • Built with GeneratePress