declare @dbo varchar(50) set @dbo = 'Dbo.seq_' declare @tableID varchar(10) set @tableID = 'SOMETABLEID' declare @sql varchar(500) set @sql = 'alter sequence' +@dbo+@tableID + 'minvalue' +CAST(YOURRECIDValue as bigint) +'restart with' +CAST(YOURRECIDValue as bigint) exec (@sql)
public static int64 alterRecId(TableId _tableId, int64 _maxRecId) { //Run SQL to alter seq id //alter sequence dbo.seq_7051 minvalue alterRecId restart with alterRecId int64 alterRecId = _maxRecId+1; const str sqlStatementText = "declare @dbo varchar(50) set @dbo = 'Dbo.seq_' declare @tableID varchar(10) set @tableID = @SelectedTableId declare @sql varchar(500) set @sql = 'alter sequence ' +@dbo+@tableID + 'minvalue ' + @AlterRecId + 'restart with' + @AlterRecId exec (@sql)"; var connection = new Connection(); Statement statement = connection.createStatement(); Map paramMap = SqlParams::create(); paramMap.add('SelectedTableId', _tableId); paramMap.add('AlterRecId', alterRecId); var results= statement.executeQueryWithParameters(sqlStatementText, paramMap); results.next(); str result1 = results.getString(1); alterRecId = str2Int64(result1); statement.close(); return alterRecId; }
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 684 Super User 2025 Season 2
CA Neeraj Kumar 588
Martin Dráb 542 Most Valuable Professional
