Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Keep the SQL Scope_Identity() value

Avatar

Level 2

I’ve got a process that inserts data into a sql server using the Execute SQL Statement.

I use the Scope_Identity() to get the index value for subsequent inserts to other tables.

Is there a way to get that value back into the process?

I need to know the value several steps later.

0 Replies