farmwang的专栏

create table TT(tablename nvarchar(128),columnname nvarchar(128),columndata nvarchar(max)); use changyu; --使用数据库 declare @t11 varchar(50) declare @c1 varchar(50) declare @b1 varchar(10) dec...

WITH XMLNAMESPACES (DEFAULT 'http://www.mesa.org/xml/B2MML-V0600', 'http://www.mesa.org/xml/B2MML-V0600-AllExtensions' AS Extended) select * from ( select m.MESSAGE_ID, m.XSLT_TRANSFORMED_CONTEN...

SELECT TOP 10 t.NAME AS TableName, s.Name AS SchemaName, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, SUM(a.total_pages) * 8 / 1000 AS TotalSpaceMB, SUM(a.total_pages) * 8 / 1000000 ...