Monthly Archives: February 2010

Generate random and unique alphanumeric code in SQL

The key to generating large number of random and unique alpha numeric code is to generate all of it in one go. Store all the codes in a file or a table and server the requested amount of codes whenever … Continue reading

Posted in Programming, SQL | Tagged , , , , , , , , , , , | 8 Comments

Convert string to ASCII

A simple SQL function I created to convert a string to ASCII values. This function is build as per my requirements but you can modify it to get desired results. For example you can replace with to get a delimited … Continue reading

Posted in Programming, SQL | Tagged , , , , , | Leave a comment