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-27 : 22:33:02
|
| Hi guys,I 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 temp_aaaend--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..... |
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2008-01-27 : 22:36:09
|
| oops i am sorry...in the stored proc which i tried...there is select * from processingtbl (not select * from temp_aaa) |
 |
|
|
|
|
|
help with stored proc....