摘要：
update dbo.LeaveDocuments set DataDay = convert(float , (SELECT DATEDIFF(day, CreateTime , getdate()) AS no_of_daysFROM dbo.LeaveDocuments where LeaveID = 'ZYQJ2013030002')) where TaskID =188 阅读全文
|
摘要：
update dbo.LeaveDocuments set DataDay = convert(float , (SELECT DATEDIFF(day, CreateTime , getdate()) AS no_of_daysFROM dbo.LeaveDocuments where LeaveID = 'ZYQJ2013030002')) where TaskID =188 阅读全文
|