存储过程求助,大牛
Create procedure prGetOrder1
AS
begin
declare @strMgDn varchar(16)
declare @strMedDn varchar(16)
select MaskedDn from UserList
where
-- -- @strMgDn=MaskingDn @strMedDn=MaskedDn //变量在哪里可以赋值???
(select Mid from DnRange where left(@strMgDn,3)=Mac)=(select Mid from DnRange where left(@strMedDn,3)=Mac)
end
情况如下,
有2张表,表UserList相关有2个列,叫MaskingDn 和MaskedDn ,表DnRange 相关有3列 Mid,Mac