?? sql.txt
字號:
if @object_type=N'13' and @transaction_type =N'A'
begin
insert txsbo..T_SMSSendList( S_ReceiveCardNo ,S_SendContent )
select top 1 C.Cellular ,Content=N'你的發(fā)票:'+ isnull(O.NumAtCard,'')+N' '+cast(O.docnum as nvarchar) +N' 己開'
from OINV O Inner join OCRD C on C.cardcode=O.cardcode and isnull(C.Cellular,'')<>''
where O.docentry=@list_of_cols_val_tab_del
end
else
if @object_type=N'15' and @transaction_type =N'A'
begin
insert txsbo..T_SMSSendList( S_ReceiveCardNo ,S_SendContent )
select top 1 M.Mobile,Content=N'客戶:' + O.cardcode+N' '+O.cardName+N',單號是:'+cast(O.docnum as nvarchar)
+ N' 己經(jīng)發(fā)出'
from ODLN O inner join Oslp P on O.slpcode=P.slpcode
inner join OHEM M on P.Slpcode=M.salesprson
where O.docentry=@list_of_cols_val_tab_del
end
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -