Post reply

Update statement problem

  • August 27, 2007 at 5:42 am

    #180487

    I used to be able to do the following in SQL 2000 without any problems:

    Update <table1>

    Set <field1> = (Select <field2> From <table2> t2 Where t2.<PKField> = <FKField&gt

     

    Now in SQL 2005 when I check syntax the query gets rewritten automatically to:

    Update <table1>

    Set <field1> =

    (Select <field2> From <table2> AS t2 Where <PKField> = <FKField&gt

  • August 27, 2007 at 8:34 am

    #729560

    Do you mean the formatting or the alias or both?

    Not sure what the problem is?

  • August 27, 2007 at 8:36 am

    #729561

    This was an accidental post.  See other post with same name.  I could not find a delete to remove this one.

    Don

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply