8 lines
250 B
SQL
8 lines
250 B
SQL
DISABLE TRIGGER ALL ON T_CIM;
|
|
UPDATE Cim
|
|
SET Cim.C_KOZTERULETJELLEGENEV = dib.C_NAME
|
|
FROM T_CIM Cim
|
|
INNER JOIN T_DICTIONARYITEMBASE dib ON Cim.C_KOZTERULETJELLEGE = dib.ID
|
|
AND Cim.C_TANEVID = dib.C_TANEVID;
|
|
ENABLE TRIGGER ALL ON T_CIM;
|