摘要：SELECT convert(varchar(8),dateadd(ms,-3,DATEADD(dd, DATEDIFF(dd,0,@trdt), 0)) ,112) --上一天SELECT convert(varchar(8),dateadd(ms,-3,DATEADD(wk, DATEDIFF(wk,0,@trdt), 0))-1 ,112) --上一周SELECT convert(varchar(8),dateadd(ms,-3,DATEADD(mm, DATEDIFF(mm,0,@trdt), 0)) ,112) --上一月SELECT convert(varchar(8),datea 阅读全文

摘要：create function fn_getPY(@str nvarchar(200)) returns varchar(100) as begin declare @word nchar(1),@PY nvarchar(4000) set @PY='' while len(@str)>0 begin set @word=left(@str,1) --如果非汉字字符，返回原字符 set @PY=@PY+(case when unicode(@word) between 19968 and 19968+20901 then (select top 1 PY from ( s 阅读全文