database
newsgroups
Home
All Groups
Group
Topic
Archive
Search
About
Update a selected number of records in an UPDATE statement
microsoft.public.sqlserver.programming
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?
Other interesting topics
How To incorporate table-valued function in Common Table Expressio
Getting 10 Records the Fastest Way Possible // ROWLOCK, UPDLOCK, READPAST
Using ranking functions in a subquery to feed a CLR function values in a specified order.
Challenging Query - Please Help
JOIN Question...
related:
Tech news groups
SQL database news
MS news
Net developer
Code news
Security news