摘要:
SELECT CountDate=CONVERT(CHAR(10),DATEADD(DAY,0-rn,GETDATE()),20)FROM (SELECT TOP 7 rn=row_number() OVER(ORDER BY GETDATE())-1 FROM sysobjects)t ORDER... 阅读全文
摘要:
要转换的XMLDECLARE @xml XML=N'55.376.98'SELECT N.v.value('.', 'decimal(24,4)') AS I_RNumber, N.v.value('@id[1]', 'int') AS IType FROM @xml.nodes('/root/pa... 阅读全文