create procedure [dbo].[userlogin] 
@username nvarchar(20) output, 
@secretcode nvarchar(50) output, 
@authority char(3) output 
as select @username=dbo.user_table.usrrname, 
          @secretcode=dbo.user_table.secret_code, 
          @authority=dbo.user_table.authrity 
from dbo.user_table where dbo.user_table.usrrname=@username