colin Robinson (4/21/2008)
Thanks for the pointer,That would make a decent interview question. and it least a truncate means you can retain permissions etc.
Thanks for the feedback... Correct... no need to rebuild any permissions that way...
Not sure it makes such a great interview question... if too many people ask it, others hear of it and it becomes one of those things people simply memorize without ever having done it. I rather like weaving it into a simple multi-statement code example and ask them questions about what the intermediate and final result set's would be. Sure, memorization could still help there, but at least I know that they know when it applies and what it actually does and when.
--Jeff Moden
Change is inevitable... Change for the better is not.