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

Pages: 1-

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

Name: Anonymous 2012-10-08 4:58

>>2
Not yelling, it's the case I use for my code.

Name: Anonymous 2013-09-01 13:51



   /i
  .| |
  | |
 .| |
 | |    __ノ ̄i. __,,,.........,,,__
 | |    ) ヽ、_ゝ-        `ヽ、
 | |    `y'"        `ヽ、 ヽ,
 .| |.    イ / / ⌒/ i  i⌒', ',   ',
 .| |    Lハ__L/ i__ハ__ハ___i .l   i
  | |.     ノ iT!'j   <  ト-┘  |
  .i i     ´7〈""  r─,  ""|   ノ  ..:::::::...
  l l__   く__,iゝ、_ ヽノ  ,.イ_ノ_i^i  ::   ::::::
 ⊂ ̄_ゝ、    `´_'ヽ'ハヘT´_/ヽ-ハ,.ト-、 ::  ::::::
  `! (、 i、  ,γ´ ヘ (ハ)´〒 /(つ   〉:  :::::
   iミiヽ、   ̄)  /  Y 。  i _`T ´|  :::::
   .lミl  ` ̄ ^ーイ  ハ ゚  .ハ"7/  i  :::
   

Name: Anonymous 2013-09-01 15:21



          ,.へ,.へ -‐─- 、.,_
         ,. >、 `く       `' 、
       ., ' く_,.へ._> ,       ヽ、
       /    . '´  / l    ハ 、 ハ`フ   ___
      ,'   ,'   ,' /__'、   |/_|_ ハ  'r'     | r──┘ 
      l   / ,  .|/__」/_、 | _」/! }  }     | | l二二`l
      | ∠.イ|  「 l)l::}` \|´l:l!}|/ 八    | | く\/ /
      ',   八   'ひ-'    `"oイ ̄`   ; ;  > ,.く
       ',  /  l 、._,ゞ"      "}リ      く/ く/\>
       }     |  ト 、   ´   ,.イ!
       ノ    八 ', }  ーrァ升| |        r、 「l r、
   ト-‐''´    ,:' ,ハ ∨\ _ハ ヽ! |       くノ | /ゝ'
   `>'´   //´ヽレ'、|`}_アrr'7ハ |        / ' ー┐
  /    , '  '   ∨   ○ ∨!八      r'_イ.l三 l l
 ,: '     /    {    、   △  } |   ',       | l二 l |  
 {     ;    ∧    ヽ  × | |   ,.       └' ̄`┘
  、    、   ;  ',     \.八 '、!   }
  \    \ , く \   /`7ヽYヽ  ;     ___「l___
    )  ノ, /  `ア`' 、/ /__八,ハ}、/     | r‐┐r‐┐!
   (r'´ (, '     ./    ` ´ ヽ  ̄ ヽ.      | |_| |_| |
    `   {     ;         ',    ハ.     └‐ ┐r─┘
      ,-{ ` 、.,_、        ,     }        .|_|
    / ,r>、.,__ 、>-‐- 、.ノ  ノ    rノ、
     {_く_r、_,,.. -、_,.. -、_>イ__.>-く__r'

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