Home Forums SQL Server 2005 T-SQL (SS2K5) Use Table Column Contents As Where Clause RE: Use Table Column Contents As Where Clause

  • December 6, 2008 at 2:26 am

    #908777

    Derek (12/6/2008)

    I would think WHERE (dbo.tblSkillsetType.SQLSnippet) would cause an error

    Yes it will. The where clause must consist of conditions, where one expression is compared against another. As I said in my reply to your other post, the only way you're going to do this is Dynamic SQL.

    Be aware of the downsides of dynamic SQL and watch for SQL injection.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass