sql server new users: is there a simple way to encrypt/decrypt a field in SQL table? -- sql server new users

RE: is there a simple way to encrypt/decrypt a field in SQL table?

Chandra
5/25/2005 6:31:02 AM

sql server new users:

hi
Check for undocumented functions
pwdencrypt
pwdcompare

INSERT INTO <TABLE> (userID, password) VALUES (1, pwdencrypt('<pwd>'))

SELECT @test = password FROM <TABLE> where UserID = 1
PRINT pwdcompare('<pwd>',@test );

pwdcompare returns 1 if the pwd is correct else, it returns 0

--
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---------------------------------------

[quoted text, click to view]

Re: is there a simple way to encrypt/decrypt a field in SQL table?

Keith Kratochvil
5/25/2005 8:01:35 AM

You will have to do it programmatically (via code) within your application.

--
Keith

[quoted text, click to view]

is there a simple way to encrypt/decrypt a field in SQL table?

Matt Landis
5/25/2005 8:18:29 AM

Hello,

Is there a simple way to e/d a field in SQL table?

Thanks,
Matt

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.