Update Multiple records in SQL Server

Posted by Yongwei Xing on Stack Overflow See other posts from Stack Overflow or by Yongwei Xing
Published on 2010-05-19T13:00:41Z Indexed on 2010/05/19 13:10 UTC
Read the original article Hit count: 180

Filed under:
|
|

Hi all

Here is my situation:

I use the SqlCommond to update some records in the SQL Server in a ASP.NET web site. Users can choose which records they want to update. Sometimes they may choose 40 or 60 records to update at a time.Is there any good way to do it? I do not want to do like it

foreach(string ID in List)
{
   Update here
} 

Best Regards,

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about tsql