Untitled

mail@pastecode.io avatar
unknown
plain_text
a month ago
1.0 kB
2
Indexable
Never
--- Kazanç tür transferi
-- Örnek JSON verisi
SET IDENTITY_INSERT HRM.IncomeType ON
INSERT INTO HRM.IncomeType(id,[Type],[Definition],TaxStatus,TaxFreeLimit,TotalLimit)
SELECT id,[Type],[Definition],TaxStatus,TaxFreeLimit,TotalLimit
FROM ICE.HRM.IncomeType
SET IDENTITY_INSERT HRM.IncomeType OFF
--- Kazanç tür transferi

---Kazanç tanımları transferi
SET IDENTITY_INSERT HRM.Income ON
INSERT INTO HRM.Income(id,IncomeTypeId,Amount,[Description],BeginDate,EndDate,IsActive,Currency,StaffId)
SELECT id,IncomeTypeId,Amount,[Description],BeginDate,EndDate,IsActive,Currency,StaffId
FROM ICE.HRM.Income
SET IDENTITY_INSERT HRM.Income OFF
---Kazanç tanımları transferi

---Parametre grup transferi
SET IDENTITY_INSERT COR.ParamaterGroup ON
INSERT INTO COR.ParamaterGroup(id,IncomeTypeId,Amount,[Description],BeginDate,EndDate,IsActive,Currency,StaffId)
SELECT id,IncomeTypeId,Amount,[Description],BeginDate,EndDate,IsActive,Currency,StaffId
FROM ICE.COR.ParamaterGroup
SET IDENTITY_INSERT COR.ParamaterGroup OFF
---Parametre grup transferi