Ajout d'une colonne

declare @ActionID uniqueidentifier declare cSeg cursor dynamic for select ActionID from admAction where ProductIDfk = @ProductID open cSeg fetch next from cSeg into @ActionID while (@@fetch_status = 0) begin declare @NameAction varchar(50) select Name = @NameAction from admAction where admAction.ActionID = @ActionID alter table tmpReporting add @NameAction int fetch next from ActionID into @ActionID end close cSeg deallocate cSeg

Bonjour,

Si c'est bien des colonnes d'actions que tu souhaites ajouter à la table tmpReporting, tu ne peux pas passer une variable directement à la commande ALTER TABLE, ce qui explique l'erreur que te donne le compilateur :P

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
 
DECLARE @ACTIONID UNIQUEIDENTIFIER
DECLARE CSEG CURSOR DYNAMIC FOR
	SELECT ACTIONID
	FROM ADMACTION
	WHERE PRODUCTIDFK = @PRODUCTID
 
OPEN CSEG
FETCH NEXT FROM CSEG INTO @ACTIONID
WHILE @@FETCH_STATUS = 0
	BEGIN		
		DECLARE @NAMEACTION VARCHAR(50)
		SELECT  = NAME FROM ADMACTION WHERE ADMACTION.ACTIONID = @ACTIONID
 
		DECLARE @SQL VARCHAR(64)
		SET @SQL = 'ALTER TABLE TMPREPORTING ADD ' + @NAMEACTION + 'INT'
 		EXEC (@SQL) -- Ajoute la colonne
		PRINT @SQL -- Montre la commande exécutée
		FETCH NEXT FROM ACTIONID INTO @ACTIONID
	END
 
CLOSE CSEG
DEALLOCATE CSEG