sqlserver

函数记录: DateAdd:函数在日期中添加或减去指定的时间间隔,DATEADD(day/month..,number,date) getdate():系统时间 STUFF结合FOR XML PATH拼接字符串不是 varchar类型，先转CAST (xx as VARCHAR) 1234567SELECT id, [text] = '[' + stuff((SELECT ',{"bizDate":"' + CAST ( business_date AS VARCHAR ) + '","pkgCode":"' + [package_code] + '","guestType":"' + [guest_type] + '","count":' + CAST ( COUNT AS VARCHAR ) + ',&...