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 |
|
raaj
Posting Yak Master
129 Posts |
 Posted - 2008-01-28 : 08:49:16
|
| Hi guys,I have already posted this under 'SQL SERVER NEW' but didnt get any response....i am posting under this again........I am using sql server 2000I am having an excel attachment which i need to import into my database (i have done this part by using import/export wizard)...so now i am having a tbl in my database named 'processingtbl' having 5 columns named col1,col2,col3,col4 and cardnumber as follows..col1 col2 col3 col4 cardnumber1001 24653 10 298 1002 74839 20 733 1003 34690 11 988 Now, I need to write a stored proc which when i call should generate the cardnumber(by concatenating col1,col2,col3,col4) and shud encrypt it along with the import.this is wht i tried...create proc sp_getcardnumberas beginupdate processingtblset cardnumber = col1+col2+col3+col4select * from processingtblend--exec sp_getcardnumberwhen i call the above stored proc, i can generate the cardnumbers successfully..but i am not able to understand how to encrypt them along with the import..(i was also asked to think about secure passphrase to use to encrypt the card numbers)...so whts this passphrase and how to encrypt this cardnumber????? any help is really appreciable....thnx in advance....raaj..... |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-28 : 10:16:55
|
| are you using sql 2000 or sql 2005? |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-01-28 : 10:25:19
|
Which level of encryption are you needing?There is a RC4 enxruption/decryption function available on this site.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2008-01-28 : 10:51:42
|
| hithnx for ur replies guys,i am using sql server 2000and i really dont know what is the level of encryption....i am new to do this encryption and stuff |
|
|
|
|
|
|
help needed with stored proc