Re: Easy question on UPDATE


thanks Simon,

the lightbulb went off....

Simon Hayes wrote:
>See Example C under UPDATE in Books Online, and also "Changing Data
>Using the FROM Clause".
>
>Simon


--
Message posted via http://www.sqlmonster.com
.

Relevant Pages

  • Re: Easy question on UPDATE
    ... See Example C under UPDATE in Books Online, and also "Changing Data ... Using the FROM Clause". ... Simon ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Re: Update queries using more than one table
    ... See Example C under UPDATE in Books Online, and also "Changing Data ... Using the FROM Clause". ... Simon ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Re: Delete query
    ... you can consider using WHERE NOT EXISTS /EXISTS clause for such subqueries. ... > This works but is there any other query with better perforamnce, ...
    (microsoft.public.sqlserver.programming)
  • Re: Speed of SQL Query
    ... It is also a good practice to not use * with SELECT clause if ... > Which of the following would be quicker? ...
    (microsoft.public.sqlserver.programming)
  • Re: Why dosnt IIF work here?
    ... The SQL equivalent is CASE - see ... Books Online for examples. ... Simon ... Prev by Date: ...
    (comp.databases.ms-sqlserver)