SQL
Farmwang
博采众长,兼收并蓄!
展开
-
SQL遍历整个数据库查找字符串
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...原创 2018-03-30 15:31:20 · 4893 阅读 · 0 评论 -
SqlServer XML parse
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...原创 2019-02-14 16:48:02 · 335 阅读 · 0 评论 -
SQL
SELECT TOP 10t.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 ...转载 2019-02-12 17:40:52 · 110 阅读 · 0 评论