declare @deptip varchar(50)
select @deptip=:DeptIP
select a.AccidentID,a.AccidentNO,a.TTime,AcdType,a.SubDept,a.PrivyC,a.Description,
a.TecResp,a.Charge,a.TecEmployee,a.RespResult,a.StuffSuggest,a.ClientSuggest,
a.StuffResult,a.ClientResult,a.WashNO,a.RepayTotal,
case a.Checkflag when 1 then cast('是' as varchar(30))
when 0 then cast('否' as varchar(30))
end as Checkflag
from [@deptip].wash.dbo.Accident1 a
select @deptip=:DeptIP
select a.AccidentID,a.AccidentNO,a.TTime,AcdType,a.SubDept,a.PrivyC,a.Description,
a.TecResp,a.Charge,a.TecEmployee,a.RespResult,a.StuffSuggest,a.ClientSuggest,
a.StuffResult,a.ClientResult,a.WashNO,a.RepayTotal,
case a.Checkflag when 1 then cast('是' as varchar(30))
when 0 then cast('否' as varchar(30))
end as Checkflag
from [@deptip].wash.dbo.Accident1 a
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货