Linqpad allows to bypass limitation of Sql SELECT CONTAINSTABLE?

zequion · November 2021

I use Sql Server with a SELECT CONTAINSTABLE command to search for synonyms of a word. The problem is that the parameter "contains_search_condition" is limited to 4000 characters. Is there a way to get around this limitation with Linqpad?

Sample:
USE [Esp BOE - Derecho Civil]
GO

DECLARE @SQL_QUERY nvarchar(4000), @SQL_QUERY1 nvarchar(4000), @SQL_QUERY2 nvarchar(4000), @SQL_QUERY3 nvarchar(4000)

/* SET @SQL_QUERY = 'FORMSOF(INFLECTIONAL, codigo)' /
/ SET @SQL_QUERY = 'codigo|recopilación|compilación|reglamento|reglamentación|regla|norma|sistematización|sistema|metodización|método|ley' */

SET @SQL_QUERY = @SQL_QUERY1 + ' AND ' + @SQL_QUERY2

SELECT SQL_TABLE.*, FT.*
FROM [Libro_BOE - Codigo Civil y legislacion complementaria] AS SQL_TABLE INNER JOIN
CONTAINSTABLE([Libro_BOE - Codigo Civil y legislacion complementaria], [Contenido], @SQL_QUERY) AS FT
ON FT.[KEY] = SQL_TABLE.Id
WHERE (ESTADO IS NULL OR ESTADO = ' ') ORDER BY RANK, Pagina, Parrafo, Linea, Palabra

JoeAlbahari · November 2021

Have you tried replacing nvarchar(4000) with nvarchar(max)?

Linqpad allows to bypass limitation of Sql SELECT CONTAINSTABLE?

Comments