Home All Groups Group Topic Archive Search About

SQL Server database programming

microsoft.public.sqlserver.programming
Score Update a selected number of records in an UPDATE statement
Curious - 16 Nov 2007 9:39 PM - 1 message
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 ...
Next »