【问】自助收银机提示找不到加密狗

自助收银机提示找不到加密狗

请在服务器上执行下面存储过程后再试试，自助对接那个数据库就在那个数据库上执行

cREATE procedure pr_auto_pos_getbranchname
(
@as_branchno varchar(50)
)
WITH ENCRYPTION
as
begin
declare @branchName varchar(50)
declare @trade_type varchar(1)
declare @property varchar(1)

select @branchName = branch_name
from t_bd_branch_info
where branch_no = left(@as_branchno,2);

select @property = property,@trade_type =trade_type
from t_bd_branch_info
where branch_no = @as_branchno;

select isnull(@branchName,'')as branch_name,isnull(@trade_type,'') as trade_type,isnull(@property,'') property
end