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: 226
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
