CREATE PROC [dbo].[Proc_UpdateUploadStatus] @AutoIDList VARCHAR(4000) AS BEGIN UPDATE ProductDetectionDetail SET UploadFlag = 1 FROM DBO.DismemberStr(@AutoIDList, ',') A WHERE ProductDetectionDetail.AutoID = A.FV SELECT @@ROWCOUNT END