title: Using "IN" in a WHERE clause where the number of items in the set is very large
body: <p>I have a situation where I need to do an update on a very large set of rows that I can only identify by their ID (since the target records are selected by the user and have nothing in common other than it's the set of records the user wanted to modify).  The same property is being updated on all these records so I would I like to make a single UPDATE call.  </p>
  
  <p>Is it bad practice or is there a better way to do this update than using "WHERE IN (1,2,3,4,.....10000)" in the UPDATE statement?  </p>
  
  <p>Would it make more sense to use individual update statements for each record and stick them into a single transaction? Right now I'm working with SQL Server and Access but,if possible, I'd like to hear more broad best-practice solutions across any kind of relational database.</p>