SQL Source Control can't parse my script, SqlServer 2008 do
Cactus
Posts: 2
I'm having almost the same error as this post: http://www.red-gate.com/messageboard/viewtopic.php?p=43223&sid=2272a2786f47b8a076b955eb6f464af4
But my problem is with the method CONTAINS using the LANGUAGE keyword.
Here's a part of my query:
SELECT @CountRetailer = COUNT(*)
FROM RetailerSearchView ret
WHERE ret.IsActive = 1
AND
(
@RetailerCategoryId = 0 OR
ret.PrimaryCategoryId = @RetailerCategoryId OR
ret.SecondaryCategory1Id = @RetailerCategoryId OR
ret.SecondaryCategory2Id = @RetailerCategoryId
)
AND CONTAINS(*, @SearchCondition, LANGUAGE @Language)
and your parser seems to dislike the LANGUAGE @Language part of the CONTAINS method.
But my problem is with the method CONTAINS using the LANGUAGE keyword.
Here's a part of my query:
SELECT @CountRetailer = COUNT(*)
FROM RetailerSearchView ret
WHERE ret.IsActive = 1
AND
(
@RetailerCategoryId = 0 OR
ret.PrimaryCategoryId = @RetailerCategoryId OR
ret.SecondaryCategory1Id = @RetailerCategoryId OR
ret.SecondaryCategory2Id = @RetailerCategoryId
)
AND CONTAINS(*, @SearchCondition, LANGUAGE @Language)
and your parser seems to dislike the LANGUAGE @Language part of the CONTAINS method.
Comments
Which version are you using? I've tried replicating the issue here on a similar script and it seems to work; however I'm using a version 2 EAP.
Redgate Software