- 博客(12)
- 资源 (2)
- 收藏
- 关注
原创 Xml Indexing
XML indexing consists of two categories: primary and secondary indexes. These two indexes types provide an indexing relationship within the XML documents similar to the relationship between clustered
2012-08-28 06:19:34 614
原创 T-SQL XQUERY.MODIFY
UPDATE XmlsampleDB.dbo.Arthur SET BooksXML.modify(' insert into /books[1]') WHERE region = '台北'DECLARE @bn NVARCHAR(max) = '剑'SELECT ArthurName,Region,CONVERT(NVARCHAR(max),Books
2012-08-28 05:04:41 1576 1
原创 T-SQL XQUERY.NODES
SELECTarthurname,region,n.c.query('.') AS BookNameFROM [XmlsampleDB].[dbo].[Arthur]CROSS APPLYBooksXML.nodes('/books/book') AS n(c)arthurname region BookName金庸 香港 金庸 香港 金庸 香港 金庸 香港 金
2012-08-26 09:02:17 1112
原创 T-SQL XQUERY.VARIABLE
DECLARE @bn NVARCHAR(max) = '剑'SELECT ArthurName,Region,CONVERT(NVARCHAR(max),BooksXML.query('for $s in /books/booklet $n := data($s/@name)let $p := concat($n,"-")where $s/@name[contains(.,sql
2012-08-26 07:39:37 964
原创 T-SQL XQUERY.QUERY
SELECTarthurname,region,CONVERT(NVARCHAR(max),BooksXML.query('for $s in /books/booklet $n := data($s/@name)let $p := concat($n,"-")return $p'))AS BooksListFROM [XmlsampleDB].[dbo].[Arthur]a
2012-08-26 06:19:56 942
原创 T-SQL XQUERY.VALUE
SELECTarthurname,region,BooksXML.value('/books[1]/@arthurBio','nvarchar(max)') AS ArthurBio,BooksXML.value('count(books/book)','int') AS BooksCountFROM [XmlsampleDB].[dbo].[Arthur]ORDER BYBooks
2012-08-26 06:16:55 2155
原创 T-SQL XQUERY.EXIST
SELECT*FROM [XmlsampleDB].[dbo].[Arthur]WHEREBooksXML.exist('books/book/@name[contains(.,"侠")]')=1 ANDregion ='香港arthurId ArthurName Region BooksXML3 金庸 香港 <book name="飞狐外传" /><book name="鸳
2012-08-26 06:14:48 1820
原创 MDX- CALCULATION BY ITEM()
WITH MEMBER [measures].[First Year Internet Sales Amount] AS {{[Date].[Calendar Year].&[2006],[Date].[Calendar Year].&[2007],[Date].[Calendar Year].&[2008]} *{ [Measures].[Intern
2012-08-21 04:57:53 605
原创 MDX - TOP N PARENT WITH TOP N CHILDS
WITH SET [CountryRankSet] AS Order ( NonEmpty ( [Geography].[Country].[Country].MEMBERS ,[Measures].[Internet Sales Amount] ) ,[Measures].[Internet Sa
2012-08-21 04:53:01 1273
原创 T-SQL 替换多个空格
DECLARE @Demo TABLE(OriginalString NVARCHAR(4000)) INSERT INTO @Demo (OriginalString) SELECT ' I am Incognito, What just for a test!' UNION ALL SELECT '看看 效果
2012-08-21 04:17:35 1401
原创 T-SQL 数字位位数求和
数字 123456, 求和 =1+2+3+4+5+6 =21 declare @i intset @i=123456select sum(substring(ltrim(@i),number,1)*1)from master..spt_values where type='p' and number between 1 and len(@i)
2012-08-03 23:30:58 1153 1
原创 Comparison Modeling between Excel and PowerPivot
Using the xVelocity engine without the PowerPivot add-in:Import millions of rows from multiple data sources:Relationships that exist in the external data source can be detected and i
2012-08-01 07:30:40 916
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人