SQL 插入更新的 时间 差 update dbo.LeaveDocuments set DataDay = convert(float , (SELECT DATEDIFF(day, CreateTime , getdate()) AS no_of_daysFROM dbo.LeaveDocuments where LeaveID = 'ZYQJ2013030002')) where TaskID =188