Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
akpaga
Constraint Violating Yak Guru
331 Posts |
 Posted - 2010-01-06 : 17:54:18
|
| Hi i have a table customer with following fieldscustomernumber ,customer_email_id,customer_random_number.i have an csv file with customernumber and customer_email_id info.i would like to upload this file into the customer table from a front-end aspx page. while doing that i want to populate the customer_random_number filed to be poulated with 6 digit unique random code which i would later use for sending out emails.Please sugggest .Thank you |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2010-01-06 : 18:18:50
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=118041&SearchTerms=random,number<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-07 : 00:46:29
|
| alsohttp://sqlblogcasts.com/blogs/madhivanan/archive/tags/random+numbers/default.aspx |
|
|
|
|
|
|
generate a random number as field value