Entity Framework调用表值函数实现全文检索?
摘要:CREATE FUNCTION [dbo].[udf_BookContentSearch](@keywords NVARCHAR(1000))RETURNS @BookPageDetail TABLE ( BookPageDetailID int PRIMARY KEY NOT NULL, [RANK] INT NOT NULL)ASBEGININSERT INTO @BookPageDetail(BookPageDetailID,[RANK]) SELECT [KEY],[RANK]FROM CONTAINSTABLE(CM_BookPageDetail,(Content,Memo),@ke
阅读全文
posted @ 2014-03-25 11:35