?? 查看未銷未領未報損的機子所有信息.sql
字號:
/*********************************
查看未銷/未領/未報損/的機子所有信息
*************************************/
declare @act int --1為按類型2按串號3所有
declare @val char(5)--型號
set @act=1
set @val='XH007'
--set @val='234234'
if @act=1
begin
SELECT *
FROM vAllSj a
where a.fid not in (select fcode from thxc) and a.fid not in (select fhrxx from tgtlh) and a.fid not in(select fhrxx from tbs) and a.fsjxhid=@val
end
if @act=2
begin
SELECT *
FROM vAllSj a
where a.fid not in (select fcode from thxc) and a.fid not in (select fhrxx from tgtlh) and a.fid not in(select fhrxx from tbs) and ltrim(rtrim(a.fno))=ltrim(rtrim(@val))
end
if @act=3
begin
SELECT *
FROM vAllSj a
where a.fid not in (select fcode from thxc) and a.fid not in (select fhrxx from tgtlh) and a.fid not in(select fhrxx from tbs)
end
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -