- 博客(14)
- 资源 (2)
- 收藏
- 关注
原创 SQL SERVER 2012 文件表(FILETABLE)新体验之二
上文我们看到文件表功能,现在来看看如何在文件表使用SEMANTIC SEARCH. 1,我们新建两个WORD文档,文档来自:点击打开链接 TEST1.DOCX包括两个段落,TEST2.DOCX包括三个段落.目的是用于比较. 2,首先选择两个文档的前十个关键词TEST1TEST2 显然,两个有区别. 3,最后,我们来比较一下这两
2012-03-31 01:29:15 1587 2
原创 SQL SERVER 2012 文件表(FILETABLE)新体验之一
SQLSERVER 2012 文件表功能很COOL,让我们体验一下吧. 1,创建数据库DREATE DATABASE FileTableTestON PRIMARY( NAME = N'FileTableTest', FILENAME = N'D:\Data\FileTableTest.mdf'),FILEGROUP FilestreamGroup1 DONT
2012-03-31 01:10:20 2392 1
原创 BISM TABULAR MODEL 分集(EXCEPT)一个实例
use ExcelExercisego--===== Create the test table CREATE TABLE Purchase ( PurchaseID INT IDENTITY(1,1), CustomerID INT, ProductCode CHAR(1) PRI
2012-03-30 09:21:29 1175
原创 SSAS Tabular model 多多关系一个实例
SSAS Tabular model 解决多多关系非常容易,下面看个例子。 USE [ExcelExecise]GO/****** Object: Table [dbo].[产品表] Script Date: 08/19/2011 02:21:03 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI
2012-03-30 06:49:58 3149
原创 semantic search examples
Example 1: Find the Top Key Phrases in a Specific DocumentThe following example retrieves the top 10 key phrases from the document specified by the @DocumentId variable in the Document column of the
2012-03-25 00:35:28 665
原创 semantic search
Create a Semantic Index When There Is No Full-Text IndexExample 1: Create a unique index, full-text index, and semantic indexCREATE FULLTEXT CATALOG ft AS DEFAULTGOCREATE UNIQUE INDEX ui_ukJobC
2012-03-25 00:11:00 784
原创 full-text search examples
A. Using CONTAINS with The following example finds all products with a price of $80.99 that contain the word "Mountain". USE AdventureWorks2012GOSELECT Name, ListPriceFROM Production.Produ
2012-03-24 23:53:37 378
原创 full-text search
1,catalogUSE AdventureWorks;GOCREATE FULLTEXT CATALOG AdvWksDocFTCat;2,unique, single-column, non-nullable indexCREATE UNIQUE INDEX ui_ukDoc ON Production.Document(DocumentID);3,full-t
2012-03-24 23:41:28 534
原创 Microsoft Access Database Engine 2010 Redistributable
If you are the user of an application, consult your application documentation for details on how to use the appropriate driver.If you are an application developer using OLEDB, set the Provider argum
2012-03-24 07:36:43 2254
原创 ADOMD.NET的参数查询
OLE DB 还是 ADOMD.NET, 肯定是后者,它支持参数查询 using System;using System.Data.OleDb; class Program { static void Main() { string connectionString =@"Provider=MSOLAP;Data Source=localhost;Catalog
2012-03-21 06:32:47 786
原创 DQS的认识二
DQS ComponentCapabilitiesData Quality ClientKnowledgebase Management: Creating and maintaining a DQKB, including: Knowledge management: A set of functionalities that en
2012-03-19 02:18:47 6729
原创 DQS的认识一
Data Quality IssueDescriptionCompletenessIs all the required information available? Are data values missing, or in an unusable state? In some cases, missing data is irrelevant, but when the
2012-03-19 02:14:25 849
原创 数据透视表的VLOOKUP模糊查找
EXCEL的VLOOKUP有模糊查找,如果最后是TRUE. 在数据透视表中,也可以实现的. 比较简单,要提醒的是,LASTNOBLANK HAS TWO PARAMETERS, THE LAST ONE CAN BE SET TO 1.
2012-03-19 01:47:08 2000
原创 POWERSHELL的一个函数
也许有用的,一个函数function Get-SQLserverKey { param ($targets = ".") $hklm = 2147483650 $regPath = "SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Setup" $regValue1 = "DigitalProduct
2012-03-19 01:37:32 503
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人