This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Thanks for the suggestion aelam. The main topic/issue/question at hand however is not "how" to create a Record ID (or similar) using In-DB tools, but rather a workaround for the short coming of the Write-In-DB tool not being able to write data to a table with an identity column (SQL Server itself is the one who populates this field).
Apologies, I should've been more specific and pointed in my original reply. The suggestion by @RodL does work to create a RecordID, but it doesn't help if you have a table with an identity column and don't want to change its current setup. Currently, there is no solution for that. I've suggested it as an idea here: Allow for a column list to be specified when using the Write Data In-DB tool