Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon. Entire thread

T-SQL Variable Question

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

Name: Anonymous 2012-10-08 4:30

STOP YELLING

Newer Posts
Don't change these.
Name: Email:
Entire Thread Thread List