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 |
|
Ali.M.Habib
Yak Posting Veteran
54 Posts |
 Posted - 2009-08-19 : 10:16:41
|
| create table Test(INST_NO binary(3),PROS_YYYYMMDD binary(8),REC_YYYYMMDD binary(8),REC_HHMMSSHS binary(8),FROM_INST_NO binary(3),FROM_ACCT_NO binary(16) )INST_NO ,PROS_YYYYMMDD,REC_YYYYMMDD,REC_HHMMSSHS are primary keysI want to make the data in REC_HHMMSSHS random and not be repeated How can I do that |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-08-19 : 10:30:24
|
| You mean you want to create random binary values with no dupes? Post an example of what the data should look like - should it be meaningfull in any way?Just out of curiosity, why are these all binary datatypes? Looks like some of the data represents datetimes. Why not use DATETIME?Be One with the OptimizerTG |
 |
|
|
|
|
|
how to do that