2,366
Share
Reportdeclare @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)
All responses (
Answers (
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;
}
#1
André Arnaud de Cal...
292,886
Super User 2025 Season 1
#2
Martin Dráb
231,766
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
