How to use OUTPUT in update statement?
Open
enhancement
sql server
- Dominant language
- Kotlin
- Stars
- 9.3k
- Forks
- 798
- Avg merge
- 4d 2h
- Merged PRs (30d)
- 26
Description
I need a user's country when I was update the user. I looked at a lot of places but couldn't see a similar use.
```
UPDATE users
SET name = 'kibar'
OUTPUT inserted.country
WHERE users.id = '--userid--'
```
Contributor guide
Assessment
This issue has not been assessed yet.