OUTPUT句に**$action**を指定する
MERGE INTO table_name
...
WHEN MATCHED WHEN
...
WHEN NOT MATCHED WHEN
...
OUTPUT
$action AS RESULT_STRING -- nvarchar(10) 'INSERT' または 'UPDATE' または 'DELETE' が入る
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme