SQL Server Performance

Query help

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

  1. dnpmoris New Member

    Hi

    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".

    Naveen
  2. Luis Martin Moderator

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


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    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