Table
-----

ID   user   Email
---  ----   ----------
10    sam    sam@g.com
20    pat    pat@p.com 
30    Rob    Rob@r.com 
40    Jack   Jack@j.com  

Update table set ID = 10,user = 'sam', cdate = getdate() Where Email = 'sam@g.com'
Update pat@p.com set ID = 20,user = 'pat', cdate = getdate() Where Email = 'pat@p.com'
Update pat@p.com set ID = 30,user = 'Rob', cdate = getdate() Where Email = 'Rob@g.com'
Update pat@p.com set ID = 40,user = 'Jack', cdate = getdate() Where Email = 'Jack@g.com'