Скрипты обработки прайсов
Импортированный прайс записывается во временную таблицу формата:
Код
TABLE #TMP_PRICE(
[ID] [int] IDENTITY (1, 1) NOT NULL,
[ROW_NUMB] [int] NULL ,
[NAME] [text] COLLATE Cyrillic_General_CI_AS NULL,
[BRAND] [text] COLLATE Cyrillic_General_CI_AS NULL,
[SID] [text] COLLATE Cyrillic_General_CI_AS NULL,
[ARTIKUL] [text] COLLATE Cyrillic_General_CI_AS NULL,
[DESCRIPTION] [text] COLLATE Cyrillic_General_CI_AS NULL,
[NOTES] [text] COLLATE Cyrillic_General_CI_AS NULL,
[PRICE] [text] COLLATE Cyrillic_General_CI_AS NULL,
[WARRANTY] [text] COLLATE Cyrillic_General_CI_AS NULL,
[PRESENT] [text] COLLATE Cyrillic_General_CI_AS NULL,
[REST] [text] COLLATE Cyrillic_General_CI_AS NULL,
[CATEGORY] [text] COLLATE Cyrillic_General_CI_AS NULL,
[URL] [text] COLLATE Cyrillic_General_CI_AS NULL,
[IMAGE_URL] [text] COLLATE Cyrillic_General_CI_AS NULL,
[DESC_FULL] [text] COLLATE Cyrillic_General_CI_AS NULL,
[CURRENCY] [text] COLLATE Cyrillic_General_CI_AS NULL,
[CURRENCY_RATE] [text] COLLATE Cyrillic_General_CI_AS NULL,
[PRICE2] [text] COLLATE Cyrillic_General_CI_AS NULL,
[CURRENCY2] [text] COLLATE Cyrillic_General_CI_AS NULL,
[CURRENCY_RATE2] [text] COLLATE Cyrillic_General_CI_AS NULL,
[SERIES] [text] COLLATE Cyrillic_General_CI_AS NULL,
[PRODUCER_CODE] [text] COLLATE Cyrillic_General_CI_AS NULL,
[PARTY] [text] COLLATE Cyrillic_General_CI_AS NULL,
[COUNT_IN_PACKING] [text] COLLATE Cyrillic_General_CI_AS NULL,
[COLLECTION] [text] COLLATE Cyrillic_General_CI_AS NULL,
[SEASON] [text] COLLATE Cyrillic_General_CI_AS NULL,
[MIN_ORDER] [text] COLLATE Cyrillic_General_CI_AS NULL,
[DELIVERY] [text] COLLATE Cyrillic_General_CI_AS NULL,
[PRODUCER_COUNTRY] [text] COLLATE Cyrillic_General_CI_AS NULL
);
Назначения полей этой временной таблици надеемся понятны и соответствуют полям таблици товаров справочника товаров поставщиков.
Всё остальное - чистый Transact-SQL (T-SQL), литературы и информации по которому полно. В поставке самого MS SQL Server есть обширная справочная документауия именуемая Books online - которой обычно вполне хватает для начала, но она на английском.
|
