Re: Trigger For DateTime



Awesome Erland, thanks that's what I was looking for!

I've never seen a FROM / JOIN on an update statement before. I assume
the JOIN insures that only the rows in the table that match the rows in
the inserted table are modified rather than the whole table?

What's the FROM clause for though? Is it required? Or was it just so
you could alias the table to save typing?

Thanks again for your help.

.

Relevant Pages

  • Re: Cool Query Analyzer Trick
    ... update statement, press Ctrl-Shift-M... ... Jacko ... Prev by Date: ...
    (microsoft.public.sqlserver.tools)
  • Re: Very slow distinct select
    ... Thanks Dan and Erland... ... > When I do a select like this it takes forever: ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Re: Check Constraints or Triggers
    ... Erland and AK: ... data consistency. ... Thanks for your valuable feedback ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Re: Concatenating strings from different rows
    ... Well Erland, Thanx for the reply. ... Hmmm and i thought i found a better ... Hennie ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Re: help
    ... an update statement instead of select ... Thanks & Regards ... Prev by Date: ...
    (comp.databases.ms-sqlserver)