Home All Groups Group Topic Archive Search About

Update a selected number of records in an UPDATE statement

Author
16 Nov 2007 9:39 PM
Curious
I have a query that will update a few thousand records if run:

    UPDATE DistributionPrintReceiptInstance dpri
    SET ReceiptTime = NULL

I only want to update 100 records. How can I achieve this in this SQL
statement?

AddThis Social Bookmark Button