Cannot find data type SYSNAME
Bonjour,
j'aurais encore une question à vous posez. J'obtiens ce message d'erreur:
Code:
1
2
3
| Msg 2715, Level 16, State 3, Server SKISS, Line 3
Column or parameter #-4: Cannot find data type SYSNAME.
Parameter '@idJob' has an invalid data type. |
Avec ce code:
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
| USE master
GO
SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON
GO
USE Esl;
Go
DECLARE @i_genre INT,@booleen INT, @NB VARCHAR(100);
DECLARE @idJob SYSNAME,
@SQL NVARCHAR(4000);
SET @booleen=0;
WHILE @booleen = 0
BEGIN
DECLARE idJob CURSOR
FOR
SELECT JobId
FROM Job
OPEN idJob;
FETCH idJob INTO @idJob;
SET @booleen = 1;
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT @NB=COUNT(*) FROM Job WHERE ParentJobID = @idJob;
PRINT @NB;
IF @NB = 0
BEGIN
DELETE FROM Job WHERE JobId = @idJob;
SET @booleen = 0
END
FETCH idJob INTO @idJob;
END;
CLOSE idJob;
DEALLOCATE idJob;
END;
GO |
Auriez-vous une idée?
Merci.
