收入单 [CS_IncomeVoucher_b]
SELECT id,* FROM [CS_IncomeVoucher_b] WHERE idIncomeVoucherDTO='2675'
SELECT id,* FROM [CS_IncomeVoucher_b] WHERE idIncomeVoucherDTO='2671'
SELECT * FROM [CS_IncomeVoucher_b]
DELETE FROM [CS_IncomeVoucher_b]
where [ID] = 2708;
GO
DELETE FROM [CS_IncomeVoucher_b]
where [ID] = 2712;
GO
SELECT distiNct idIncomeVoucherDTO FROM UFTData587583_020111..[CS_IncomeVoucher_b]
SELECT distiNct idIncomeVoucherDTO FROM UFTData572607_0002011..[CS_IncomeVoucher_b]
SELECT distiNct idIncomeVoucherDTO FROM UFTData572607_000201..[CS_IncomeVoucher_b]
查询收入单资料重复
SELECT idIncomeVoucherDTO,code FROM [CS_IncomeVoucher_b] group by idIncomeVoucherDTO,code having COUNT(idIncomeVoucherDTO)>1
