Encrypt function...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Yaheya Quazi (yquazi_at_ucmerced.edu)
Date: 03/24/04 

Date: Tue, 23 Mar 2004 16:35:45 -0800

Here is code for my SP

CREATE PROCEDURE insert_profiles
@email as char(100),
@password as char(100)
AS

Declare @enc_password as varbinary(85)

Set @enc_password = encrypt(@password)

INSERT INTO [profiles]
         ([email],
         [password] )
 
VALUES
        ( @email,
         @enc_password)
GO

when I try to run it, it tries to insert null into
password field! Any idea? I am using the built in encrypt
function.

Thanks.

Relevant Pages

  • Re: User profiles on domain controller - Very strange
    ... computer and encrypt files in that share. ... can use the cipher command to check for encrypted folders on a computer. ... profiles under Documents and Settings which - regarding to their name - ... The remote site is connected to our headquarter via a VPN connection ...
    (microsoft.public.win2000.security)
  • Re: Global Variable or Not
    ... Will the above not declare a different instance of Class A so wont be able ... I usually do this in a way that guarantees that if the update fails, ... > Believing a program will never crash, or a computer will never crash, is not a good ... >>contents of this vector, that has been built up over the day, and produces ...
    (microsoft.public.vc.mfc)
  • Re: VB6 to RealBasic
    ... I would be glad to learn from an experienced user a short list of those often used functions which are NOT built in what would abbreviate the learning curve significantly and enhance the chance to change over considerably. ... The old VB bit of declare this and declare that is not needed but is still available if you want to go that way. ... When I started with RB I did it the hard way and used a declare in #if TargetWin32 and shell commands for #if TargetLinux or TargetMacOS. ...
    (comp.lang.basic.realbasic)
  • Re: SQL Server Encrypt, Failure..
    ... This function doesn't encrypt at ... (Not that I had too high of expectations for a undocumented SQL ... Declare @Password2 nvarchar ... > Bill Dodd ...
    (microsoft.public.sqlserver.server)
  • Re: How do I delete an old encrypted XP profile that is no longer need
    ... I deleted all the old profiles in explorer bar one.. ... which I'd chosen to encrypt. ... The *contents* of the encrypted folder or file are what you cannot see, but the *permissions* on that folder or file are still available to the file system. ...
    (microsoft.public.windowsxp.security_admin)