SQL 语句收集

Oracle

1. 更改表所属空间

   ALTER TABLE [TABLENAME] MOVE TABLESPACE [TABLESPACENAME];

2. 插入多行数据

   INSERT INTO [TALBENAME]
   SELECT 'FIELD1',['FIELD2'] FROM DUAL
   UNION
   SELECT 'FIELD1',['FIELD2'] FROM DUAL;

MS SQL Server