1.首先copy以下的vbs脚本.并将其另存为name2comment.vbs '****************************************************************************** '* File: name2comment.vbs '* Title: Name to Comment Conversion '* Model: Physical Data Model '* Objects: Table, Column, View '* Au
SELECT cpr.Id, cpr.CreateTime, cpr.Number FROM CarParkingRegistration cpr SELECT CONCAT(FORMAT(cpr.CreateTime, 'yyyyMMdd'), FORMAT(ROW_NUMBER() OVER (PARTITION BY CAST(cpr.CreateTime AS DATE) ORDER BY CAST(cpr.CreateTime AS DATE)), '000')) FROM Car