![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
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 · 4904 阅读 · 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 · 341 阅读 · 0 评论 -
SQL
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 ...转载 2019-02-12 17:40:52 · 115 阅读 · 0 评论