RE Conditonal Truncate: Taken from: http://www.sql-server-performance.com/q&a118.asp
"You can not specify just to truncate that rows that match a certain criteria. It's either all rows or none. You can, however, use a workaround here. Suppose you want to delete more rows from a table than will remain. In this case you can export the rows that you want to keep to a temporary table, run the TRUNCATE statement, and finally reimport the remaining rows from the temporary table" With a big (read BIG!) table, that's a useful approach. Anyway.. ;o), AD7six --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~----------~----~----~----~------~----~------~--~---
