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
| create procedure UPDATE_CUSTOMER
AS
DECLARE
@name_column varchar(30),
@valeur_column_adonix varchar(50),
@valeur_column_alloga varchar(50)
DECLARE MyCursor CURSOR
FOR
select name from syscolumns where id in (select id from sysobjects where name='ADONIX_CUSTOMER')
OPEN MyCursor
FETCH MyCursor INTO @name_column
WHILE @@fetch_Status = 0
BEGIN
--print @name_column
DECLARE MyCursor2 CURSOR
FOR
select @name_column from ADONIX_CUSTOMER
OPEN MyCursor2
FETCH MyCursor2 INTO @valeur_column_adonix
WHILE @@fetch_Status = 0
BEGIN
print @valeur_column_adonix
FETCH MyCursor2 INTO @valeur_column_adonix
END
CLOSE myCursor2
DEALLOCATE myCursor2
FETCH MyCursor INTO @name_column
END
CLOSE myCursor
DEALLOCATE myCursor |
