I want to update multiple records in one instance, it can even be  a
storedprocedure.

I have data from user on a asp page. these are number of records with
different unique identifiers. how can i update the corrensonding table with
all these records with one update query.

Can somebody please give me some example.

Thank in advance,
--Nitu

Following will update the "YourColumn" column of "YourTable" with the value
'YourData', for rows where the PK column is 'Row1', 'Row2', or 'Row3':


UPDATE YourTable
SET YourColumn = 'YourData'
WHERE YourPK IN ('Row1', 'Row2', 'Row3')


news:5af30607d4efc@uwe...
Show quoteHide quote

Free up the transaction log
Insufficent memory to run this query
Maximum number of logins?
EXEC security question
Query 6.5 db
Problem using BCP
Kill command don't work
DTS (Data Transformation Services)
Missing sysjobhistory in sql job
timeout trouble in SQL Server 2005