In case you've ever wondered how cool random passwords like "rug1wh9p" are generated, you probably won't get much satisfaction from Alfred Whitehead's coworker's code. Actually, he shows you a great way *not* to generate random passwords. It is creative though. For extra fun, try guessing how many rows this will return without running the query. 

INSERT INTO 
dbo.attendee_users (password)
SELECT a.A + b.B + c.C + d.D AS Password
FROM 
  (SELECT 'a' AS A
   UNION
   SELECT 'r'
   UNION
   SELECT 'i') a 
 CROSS JOIN
  (SELECT '5' AS B
   UNION
   SELECT '2'
   UNION
   SELECT '19'
   UNION
   SELECT '4'
   UNION
   SELECT '87a3') b 
 CROSS JOIN
  (SELECT 'vgh' AS C
   UNION
   SELECT '8R7y') c 
 CROSS JOIN
  (SELECT '6' AS D
   UNION
   SELECT '7'
   UNION
   SELECT '8'
   UNION
   SELECT '9'
   UNION
   SELECT '1') d

[Advertisement] BuildMaster allows you to create a self-service release management platform that allows different teams to manage their applications. Explore how!