ERP Full Sync Query

ERP Full Sync Query Yönetimi

Query Tanımı

ERP		Adapter	Kaynak
Kod		Ad	Aktif
Count SQL	SELECT COUNT(*) FROM sys.tables
Data SQL	SELECT TOP (@BATCH_SIZE) ROW_NUMBER() OVER(ORDER BY name) AS KAYNAK_ID, name AS KOD, name AS AD FROM sys.tables ORDER BY name
Açıklama
Batch

Query Listesi

ID	ERP_KODU	ADAPTER_KODU	KAYNAK_TIP	QUERY_KODU	QUERY_ADI	COUNT_SQL	DATA_SQL	AKTIF	ACIKLAMA	OLUSMA_ZAMANI	GUNCELLEME_ZAMANI
1	MIKRO	MIKRO_SQL	ERP_STOK	DEFAULT	Mikro Stok Full Sync	SELECT COUNT(*) FROM sys.tables	SELECT TOP (@BATCH_SIZE) ROW_NUMBER() OVER(ORDER BY name) AS KAYNAK_ID, name AS KOD, name AS AD, create_date AS DEGISTIRME_TARIHI FROM sys.tables WHERE name IS NOT NULL ORDER BY name		Gerçek Mikro stok sorgusu bağlanana kadar güvenli SQL Server test sorgusu.	6.07.2026 10:09:49
2	VEGA	VEGA_SQL	ERP_STOK	DEFAULT	Vega Stok Full Sync	SELECT COUNT(*) FROM sys.tables	SELECT TOP (@BATCH_SIZE) ROW_NUMBER() OVER(ORDER BY name) AS KAYNAK_ID, name AS KOD, name AS AD, create_date AS DEGISTIRME_TARIHI FROM sys.tables WHERE name IS NOT NULL ORDER BY name		Gerçek Vega stok sorgusu bağlanana kadar güvenli SQL Server test sorgusu.	6.07.2026 10:09:49

ERP_KODU

ADAPTER_KODU

KAYNAK_TIP

QUERY_KODU

QUERY_ADI

COUNT_SQL

DATA_SQL

AKTIF

ACIKLAMA

OLUSMA_ZAMANI

GUNCELLEME_ZAMANI

MIKRO

MIKRO_SQL

ERP_STOK

DEFAULT

Mikro Stok Full Sync

SELECT COUNT(*) FROM sys.tables

SELECT TOP (@BATCH_SIZE) ROW_NUMBER() OVER(ORDER BY name) AS KAYNAK_ID, name AS KOD, name AS AD, create_date AS DEGISTIRME_TARIHI FROM sys.tables WHERE name IS NOT NULL ORDER BY name

Gerçek Mikro stok sorgusu bağlanana kadar güvenli SQL Server test sorgusu.

6.07.2026 10:09:49

VEGA

VEGA_SQL

ERP_STOK

DEFAULT

Vega Stok Full Sync

SELECT COUNT(*) FROM sys.tables

SELECT TOP (@BATCH_SIZE) ROW_NUMBER() OVER(ORDER BY name) AS KAYNAK_ID, name AS KOD, name AS AD, create_date AS DEGISTIRME_TARIHI FROM sys.tables WHERE name IS NOT NULL ORDER BY name

Gerçek Vega stok sorgusu bağlanana kadar güvenli SQL Server test sorgusu.

6.07.2026 10:09:49