SQL Server Performance

Query help

Discussion in 'SQL Server 2005 General Developer Questions' started by dnpmoris, Feb 19, 2007.

  1. dnpmoris New Member


    I need to query as below:

    select * from NaveenAgentLoc020707
    where cs_Referer ='http://www.statefarm.com/jscript/easysrch.asp' & cs_uri_stem ='/apps/agentLoc/SearchResults.asp'

    But when I execute this query as above, I ercieved an error as "Line 2: Incorrect syntax near '='."

    Can any one help me in writing "And query".

  2. Luis Martin Moderator

    I'm not developer but, did you try between "?

    Luis Martin

    All in Love is Fair
    Stevie Wonder

    All postings are provided “AS IS” with no warranties for accuracy.

  3. Adriaan New Member

    Problem is that you used the & operator instead of the AND logical operator.

    WHERE ... AND ...

Share This Page