摘要:
declare @FatherCode varchar(50)='001'; if object_id('tempdb..#Temp') is not null begin drop table #Temp end ; declare @tmp TABLE( TypeCode varchar(50) 阅读全文
摘要:
declare @annual int =2020 select * from tbName where DATEDIFF(YEAR,CAST( annual as varchar),cast(@annual as varchar)) between (case when @annual=YEAR( 阅读全文