摘要:
SELECT t.name AS TableName, c.name AS ColumnName, c.system_type_id AS DataTypeID, s.name AS DataTypeName, c.max_length AS MaxLength, c.is_nullable AS 阅读全文
摘要:
sqlserver查询每张表的大小MB SELECT t.NAME AS TableName, s.NAME AS SchemaName, p.rows AS RowCounts, SUM(a.total_pages) * 8 /1024 AS TotalSizeMB FROM sys.tables 阅读全文
摘要:
update & build @echo off rem for /f "tokens=2 delims==" %I in ('wmic os get localdatetime /value') do set datetime=%I for /f "tokens=2 delims==" %%I i 阅读全文