SQL SERVER中用預存程序驗證登陸正確性

 1. 在SQL SERVER中建立一張表 PERSON ,欄位為: USERNAME,PASSWORD
2. 寫一個預存程序來測試登陸時的正確性
3. 執行預存程序,測試語句正確性

PERSON 表內容: 
                               USERNAME        PASSWORD

                                  KATE                   C001
                                   TOM                   C002

預存程序:

                         CREATE PROCEDURE  login (

                      @pass char(10)
                         )as
                       declare @logname char(10)
                         select @logname=username from person where [password]=@pass
                     if @logname is null
                      print 'can not found'
                        else
                      print 'Login successful'
                      GO

執行預存程序:

                    exec login @pass='c001'
執行結果:

                       Login successful