18 lines
No EOL
411 B
Transact-SQL
18 lines
No EOL
411 B
Transact-SQL
DECLARE @now DATETIME2 = getdate();
|
|
UPDATE T_Munkakortipus SET
|
|
C_Alkalmazottmunkakortipusid = 8386
|
|
,Serial = Serial + 1
|
|
,Modifier = 0
|
|
,Lastchanged = @Now
|
|
WHERE
|
|
Torolt = 'F'
|
|
AND Id IN (6452, 8372);
|
|
|
|
UPDATE T_Munkakortipus SET
|
|
C_Alkalmazottmunkakortipusid = 8384
|
|
,Serial = Serial + 1
|
|
,Modifier = 0
|
|
,Lastchanged = @Now
|
|
WHERE
|
|
Torolt = 'F'
|
|
AND Id IN (8736, 8737, 8738, 8739, 8740); |