select a.*,b.*,iif(b.name ** **,'表b中不存在','成功')from a left join b on a.name=b.name and a.year=b.yearunionselect a.*,b.*,iif(a.name ** **,'表a中不存在'... 20210311
1、select a.合同编号,a.贷款金额 from 贷款信息表 a where a.客户编号 = '123456'2、select * from **表 where 客户编号 in(select 客户编号 from 贷款信息表 group by 客户编号 h**ing count(1) >=2)3、update 贷款信息表 set 贷款利率 = 贷款利率*0.1 fro...
alter function [dbo].[numtochn] (@num numeric(19,6)) returns nvarchar(100) as begin declare @n_data nvarchar(20),@c_data nvarchar(100),@n_str nvarchar(10),@i int set @n_data=right(space(14)+cast(cast(...
很,把下面sql语句中的名称换成你的字段ok。select sum(case when operate = '存款' then 信息.money else 0 end) as '款',sum(case when operate= '取款' then 储蓄信息.money else 0 end) as '款'from 储蓄信息where...