SqlServer UpdateSelect Demo
UPDATE TOP ( 100 )
SYS_USER WITH ( UPDLOCK, READPAST )
SET USER_STATUS = 1
OUTPUT INSERTED.[USER_NAME] ,
INSERTED.SYS_USERID ,
INSERTED.EMAIL
FROM SYS_USER
WHERE CREATE_DATETIME < '2018-09-13'
AND USER_STATUS = 2;