SQL

MSSQL

--------------------------------------------------------------

-- 取得sn

select @@IDENTITY

--------------------------------------------------------------

-- reduce log file

DUMP TRANSACTION TABLE_NAME WITH NO_LOG

BACKUP LOG TABLE_NAME WITH NO_LOG

DBCC SHRINKDATABASE(TABLE_NAME)

--------------------------------------------------------------

MySQL

--------------------------------------------------------------

-- LAST_INSERT_ID()

http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id

--------------------------------------------------------------

Lita - SQLite Administration Tool

http://www.dehats.com/drupal/?q=node/58

SQLite GUI 工具

--------------------------------------------------------------

bulk SQL update

UPDATE TableA SET TableA.A1 = TableB.B1, TableA.A2 = TableB.B2 FROM TableB WHERE TableA.A3 = TableA.B3