INSERT INTO PERSON (NAME,AGE)
OUTPUT Inserted.ID_PERSON --This one
SELECT NAME, AGE
FROM USER
WHERE ACTIVE = 1
Lists all inserted IDs (PK) when using an INSERT SELECT
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.