62,046
社区成员
发帖
与我相关
我的任务
分享
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