2012-02-17

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


張貼留言