Walter Meester
HoogkarspelNetherlands
General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2008
>>I do know what a Truncate command does. That's why I reacted with surprise.
>
>I think Nick was talking about the real table he wanted to clean up. If the table is big, then the usual advice is to select only rows we want to keep, truncate the table (zap in VFP) and put that saved rows back into original table. Of course, the process needs to be put in transaction.
That is the quickest, however if there is Referential Integrity involved its a different ballgame.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only