Select Top 1 word + cast(cast((RAND() * 9)+1 as int) as varchar(3)) + cast(cast((RAND() * 9)+1 as int) as varchar(2)) As Password From dictionary order by newid()

Create a random password using a Dictionary database table.
Selects a random word, and then appends two random numbers to the end,  creating passwords in the form of: foozling98 or laicism11

Creating a random password using dictionary table

sql

SQL