Blue

摘要： select cast(DATEPART(yyyy, dbo.Tran_Dingcxy.dat_Qiandrq) as varchar(4))+'-'+cast(DATEPART(m, dbo.Tran_Dingcxy.dat_Qiandrq)as varchar(2))+'-'+cast(DATEPART(d, dbo.Tran_Dingcxy.dat_Qiandrq)as varchar(2... 阅读全文

摘要： --上下两个只有一句差别，但可能导致严重后果。declare @qiyg varchar(200)declare @gangkid varchar(50)declare @count intset @count=0 declare c_1 cursor local for select distinct(str_Qiyg) from Pur_QuotePriceDTL where len(st... 阅读全文