How to generate random color hex code in database ? | Generate random hex code in database.

 You can achieve this by using below query:

"select '#' + CONVERT(VARCHAR(max), CRYPT_GEN_RANDOM(3), 2)"