After issuing an Insert using NewId() can you get the Ids that were used in that Insert

Ask Question

Asked 10 years, 1 month ago

Modified 10 years, 1 month ago

Viewed 330 times

I would like to know if it is possible to get the last inserted ID's from an Insert with Select NewId()?

asked Aug 5, 2014 at 3:11

David Gray Wright

3251 gold badge4 silver badges10 bronze badges

SELECT LAST_INSERT_ID();
– Karthick
Commented Aug 5, 2014 at 4:22
Will this return multple IDS?
– David Gray Wright
Commented Aug 5, 2014 at 23:34
LAST_INSERT_ID() is mainly to get the newly inserted Id.
– Karthick
Commented Aug 6, 2014 at 4:35

Add a comment |

0 Your Answer

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.