1.创建触发器
create if not exists trigger Trigger_SaleOrder_I AFTER INSERT ON T_SaleOrder
for each row
begin
--Logic Code
end;
2.日期判断Sqlserver中的 Datediff 在Sqlite的用法
sqlerver:
SELECT DATEDIFF(day,'2008-12-29','2008-12-30') AS DiffDate
返回结果是 1 (相差1天)
sqlite :
select DATETIME('now','start of day');
结果 2016-05-17 00:00:00
select DATETIME('now','start of day','1 hour');
结果 2016-05-17 01:00:00