SQL Server Performance

SQL CONTAINS OPERATOR

Discussion in 'General Developer Questions' started by laker_66, Apr 29, 2004.

  1. laker_66 New Member

    Hi!!!
    I was wondering how CONTAINS work in a dynamic sql statement where i have more than one table to join as below.
    FULL TEXT IS ENABLED ON TABLE emp
    This works.

    CODE
    select s.id from emp s
    WHERE CONTAINS(*, '"test"')

    This does not work

    CODE
    select s.id from emp s,emp1 s1
    WHERE CONTAINS(*, '"test"')
    and s.id=s1.id

    I know the problem is * . But not sure how to use this just for emp table and not emp1 table

    Thanks!!

Share This Page