[2016] alter séquence dans SQL dynamique

Hello ,

je cherche une méthode qui me permet de scripter dynamiquement mon opération du Alter séquence

en faite je cherche que le valeur du RESTART WITH prend la valeur maximum du mon cte

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
with cte as 
(
SELECT  convert (BIGINT , Max(TS_MAJ_CRWECSAP)) AS TS from test1
UNION
SELECT  convert (BIGINT , Max(TS)) AS TS from test1
UNION
SELECT  convert (BIGINT , Max(TS2)) AS TS from test2
)select max(TS)   from cte  
 
Alter  SEQUENCE [dbo].[REPLACEROWVERSION] 
 --AS [bigint]
 RESTART WITH 91261484039
 INCREMENT BY 1
 MINVALUE -9223372036854775808
 MAXVALUE 9223372036854775807
 CACHE  1000 
GO

Merci pour vos aides

declare @max bigint with cte as ( SELECT convert (BIGINT , Max(TS_MAJ_CRWECSAP)) AS TS from test1 UNION SELECT convert (BIGINT , Max(TS)) AS TS from test1 UNION SELECT convert (BIGINT , Max(TS2)) AS TS from test2 )select @max = max(TS) from cte declare @req VARCHAR(2500) set @req = 'Alter SEQUENCE [dbo].[REPLACEROWVERSION] RESTART WITH ' + @max + ' INCREMENT BY 1 MINVALUE -9223372036854775808 MAXVALUE 9223372036854775807 CACHE 1000' execute @req