从表中剪切数据
我们从一个表中的数据删除几条数据,然后把这些删除的数据放到另外一个表中。
Delete sourcetable
output deleted.value1,deleted.value2,deleted.value3
into targettable
from targettable where
下面是实例
delete
WaitStats
output
deleted.dt,
deleted.wait_type,
deleted.waiting_tasks_count,
deleted.wait_time_ms,
deleted.max_wait_time_ms,
deleted.signal_wait_time_ms
into new_waitestats
where WaitStats.wait_type = ' ABR '
output
deleted.dt,
deleted.wait_type,
deleted.waiting_tasks_count,
deleted.wait_time_ms,
deleted.max_wait_time_ms,
deleted.signal_wait_time_ms
into new_waitestats
where WaitStats.wait_type = ' ABR '
要注意的是这里有一个很少见的关键字deleted,它是当前要删除的表的别名,这个有点像类中的this关键字。