Stored procedure select * help

Page 1 of 1

2 Replies - 537 Views - Last Post: 24 August 2010 - 07:28 AM Rate Topic: -----

#1 rmetzger  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 36
  • Joined: 12-October 09

Stored procedure select * help

Posted 20 August 2010 - 04:26 PM

Hello. I have a sql server database and a stored procedure that selects a row from a table. The table has about 50 fields and a couple contain encrypted data. I need to select all the info using the stored procedure, but I need to decrypt the encrypted data using sql server's DecryptByPassPhrase. Is there a way that I can do "select * from table" but replace just the encrypted fields with a "select DecryptByPassPhrase"? Thanks for any help.

Is This A Good Question/Topic? 1
  • +

Replies To: Stored procedure select * help

#2 T3hC13h  Icon User is offline

  • D.I.C Regular

Reputation: 65
  • View blog
  • Posts: 337
  • Joined: 05-February 08

Re: Stored procedure select * help

Posted 20 August 2010 - 05:22 PM

You can add the decrypted columns to the select all. Something like Select *, Decrypte1,Decrypte2 From
Was This Post Helpful? 1
  • +
  • -

#3 rmetzger  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 36
  • Joined: 12-October 09

Re: Stored procedure select * help

Posted 24 August 2010 - 07:28 AM

Oops. Didn't think it would be that simple. Thanks a lot!!!
Was This Post Helpful? 0
  • +
  • -
Page 1 of 1