Guest User

Untitled

a guest
Aug 15th, 2018
492
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. fulano@gmail.com
  2. beltrano@gmail.com
  3. cicrano@yahoo.com.br
  4.  
  5. fulano@gmail.gsa
  6. beltrano@gmail.2fs
  7. cicrano@yahoo.com.gg
  8.  
  9. UPDATE pessoa
  10. SET email=STUFF(email, 1, CHARINDEX('@', email)-1, LEFT(REPLACE(CAST(NEWID() AS VARCHAR(36)), '-', ''), 4+ABS(CHECKSUM(NEWID()))%4))
  11.  
  12. 90FA2E@gmail.com
Add Comment
Please, Sign In to add comment