semanticsimilaritytable syntax error?

• djspub

  SSC Enthusiast

  Points: 106

  More actions

  May 6, 2012 at 7:07 am

  #261045

  I would like to retrieve all of the document pairs from a fulltext semantic index. Why does the query below generate a syntax error in SQL Server 2012

  CREATE table tbl (ID int primary key, txt nvarchar(max));

  CREATE FULLTEXT INDEX ON tbl(txt STATISTICAL_SEMANTICS) KEY INDEX tbl_fulltext_index;

  SELECT count(*)

  FROM tbl

  CROSS APPLY SEMANTICSIMILARITYTABLE(tbl, txt, tbl.ID)

  If I create a wrapper function

  CREATE FUNCTION SST(@ID int)

  RETURNS @SS table (

  srcColint,

  matchColint,

  matchDocint,

  scorefloat

  )

  AS BEGIN

  INSERT INTO @SS(srcCol, matchCol, matchDoc, score)

  SELECT source_column_id, matched_column_id, matched_document_key, score

  FROM SEMANTICSIMILARITYTABLE(tbl, txt, @ID)

  RETURN

  END

  then the query below is acceptable syntax and executes

  SELECT count(*)

  FROM tbl

  CROSS APPLY dbo.SST(tbl.ID)

  The wrapper function lets me do what I want to do, but I am curious about what is wrong with the original query.

• wz700

  SSCertifiable

  Points: 7133

  More actions

  May 15, 2012 at 11:31 pm

  #1488173

  Try the following

  SELECT count(*)

  FROM tbl

  CROSS APPLY SEMANTICSIMILARITYTABLE(tbl, txt, tbl.ID) a