You could write a trigger that applies ON UPDATE:
http://msdn.microsoft.com/en-us/library/ms189799.aspx
Otherwise you may use your application code to execute both queries (SET online = 0 and the other one you've mentioned), but that's considered bad practice.
mjhennig
Last Activity: Sep 11 '11, 05:05 AM
Joined: Sep 11 '11
Location:
-
You cannot avoid downloading files that are to be displayed in some way.
Well, in fact you could stream them - especially videos and audio files -, but that's basically just another way of download,..Leave a comment:
-
One cannot simply count the number of columns, rows or fields and calculate a good number of indexes. It depends on, well, many things - but primarily the type(s) of your data.
In my opinion, one can neglect the "maintenanc e overhead" of indexes on insert, update and delete operations. Some of the databases I'm operating on have tables with over 20 million entries (PostgreSQL, MySQL/InnoDB); but even concurrent modifications aren't...Leave a comment:
-
As far as I know, there's no way to do that --
Of course, you could set the opacity only for the descendant elements where you really need it (the class attribute could be useful here)..Leave a comment:
No activity results to display
Leave a comment: