摘要:
sSql = @"SELECT mwo.isosid,mwo.Qty,mwo.cInvCode,mwo.cInvName,mwo.cMac,bd.dRptDate,bd.rptPsn,bd.NGType,bd.cMem1,mwo.OperationId FROM [MO_ReportOrder] b 阅读全文
摘要:
SELECT db_name() as DbName, t.NAME AS TableName, s.Name AS SchemaName, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, CAST(ROUND(((SUM(a 阅读全文
摘要:
select a.name as 表名,max(b.rows) as 记录条数 from sysobjects a ,sysindexes b where a.id=b.id and a.xtype='u' group by a.name order by max(b.rows) desc sele 阅读全文