My project is executing several SQL scripts (with replacement) in the installation
1. Script 1, creates the Schema of the Database
2. Script 2 inserts static catalogs.
3. Script 3 inserts some tables that have a Identity column (ID)
At this point, after script 3, i need to save the last ID inserted in a property. For example:
SELECT IDENT_CURRENT('[Schema1].[MyTAble]') as lastId
And set this value in a global PROPERTY. THe issue is that I didn't find a way to execute this QUERY after the script #3 is finished
Please help.