学步园

 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