Syntax differences between SQLite and SQL Server

1. @ identity last_insert_rowid ()
2. Select Cn = count (*) from... select count (*) Cn from...
3. Limit startindex, itemcn startindex starts from 0, while row_number () starts from 1.
4. There is no select top in SQLite. Use Limit.
5. SQLite auto-increment field. If data insertion fails in the transaction, the post-increment ID is not used, and the corresponding ID in SQL Server is invalid.
6. SQLite does not have the getdate date function.
7. SQLite supports the replace into syntax, and SQL Server 2008 supports merge