SQL Server

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