Post reply

Stored Procedure

  • April 13, 2011 at 3:55 am

    #145488

    Hi I am trying to do a Login stored procedure with using email address and password

    Would it be like this:

    create procedure [dbo].[Get_Customer_Login]

    (

    @password nvarchar(255)

    @email nvarchar(255)

    )

    as

    select * from tblCustomers$

    where Password = @password

    and emailaddr = @emailaddr

  • April 13, 2011 at 4:12 am

    #1310901

    Hi,

    will the stored procedure accessed by a application and what do you want to do with this login?

    [font="Arial"]Kind regards,

    Patrick Fiedler
    Consultant

    Fiedler SQL Consulting

    www.fiedler-sql-consulting.de
    [/font]

  • April 13, 2011 at 5:46 am

    #1310949

    Have you tried it? Is it not working or are you getting an error?

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • April 13, 2011 at 4:44 pm

    #1311374

    I truly hope you're not sending the password as plain text and compare it to another plain text value....

    What concept do you use to store the password?

    @Patrick_Fiedler:

    Welcome, dear neighbor! (distance: 13km) 😀


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply