Name: Anonymous 2012-10-08 4:00
When I try to execute
DECLARE @i varchar(200) = '''ISABOUT (people WEIGHT (0.2), shock WEIGHT (0.9))'''
SELECT FT_TBL.ID, FT_TBL.txt, KEY_TBL.Rank
FROM Post AS FT_TBL INNER JOIN
CONTAINSTABLE(Post, txt, @i)
AS KEY_TBL
ON FT_TBL.ID = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK DESC
I get an error with the syntax of the containstable portion of the code. However if I don't use the variable to contain the ISABOUT portion (see blow), it executes fine. Halp?
SELECT FT_TBL.ID, FT_TBL.txt, KEY_TBL.Rank
FROM Post AS FT_TBL INNER JOIN
CONTAINSTABLE(Post, txt, 'ISABOUT (people WEIGHT (0.2), shock WEIGHT (0.9))')
AS KEY_TBL
ON FT_TBL.ID = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK DESC
DECLARE @i varchar(200) = '''ISABOUT (people WEIGHT (0.2), shock WEIGHT (0.9))'''
SELECT FT_TBL.ID, FT_TBL.txt, KEY_TBL.Rank
FROM Post AS FT_TBL INNER JOIN
CONTAINSTABLE(Post, txt, @i)
AS KEY_TBL
ON FT_TBL.ID = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK DESC
I get an error with the syntax of the containstable portion of the code. However if I don't use the variable to contain the ISABOUT portion (see blow), it executes fine. Halp?
SELECT FT_TBL.ID, FT_TBL.txt, KEY_TBL.Rank
FROM Post AS FT_TBL INNER JOIN
CONTAINSTABLE(Post, txt, 'ISABOUT (people WEIGHT (0.2), shock WEIGHT (0.9))')
AS KEY_TBL
ON FT_TBL.ID = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK DESC