MS SQL與SQLite語法使用差異

1.Top N

MS SQL  select Top 5 * from Table
SQLite  select * from Table limit 0,5

2.GETDATE()

MS SQL  select GETDATE()
SQLite  select datetime(CURRENT_TIMESTAMP,'localtime')

3.SELECT INTO

MS SQL select * into Table2 from Table
SQLite CREATE TABLE table2 AS  select * from Table