Автоматизированная система для работы поликлиники
Отчет по практике - Компьютеры, программирование
Другие отчеты по практике по предмету Компьютеры, программирование
p>@del_cmd = NVCALL [dbo].[sp_MSdel_dboнаправление_на_анализ], @upd_cmd = NVCALL [dbo].[sp_MSupd_dboнаправление_на_анализ][kp_bd]_addarticle
@publication = Npub1,
@article = Nпациент,
@source_owner= Ndbo,
@source_object = Nпациент,
@type = Nlogbased, @description = N,
@creation_script = N,
@pre_creation_cmd = Ndrop,
@schema_option = 0x0000000008035CDF,
@identityrangemanagementoption = Nnone,
@destination_table = Nпациент,
@destination_owner = Ndbo,
@status = 24, @vertical_partition = Nfalse,
@ins_cmd = NCALL [dbo].[sp_MSins_dboпациент],
@del_cmd = NVCALL [dbo].[sp_MSdel_dboпациент],
@upd_cmd = NVCALL [dbo].[sp_MSupd_dboпациент][kp_bd]_addarticle
@publication = Npub1,
@article = Nпосещение,
@source_owner = Ndbo,
@source_object = Nпосещение,
@type = Nlogbased, @description = N,
@creation_script = N,
@pre_creation_cmd = Ndrop,
@schema_option = 0x0000000008035CDF,
@identityrangemanagementoption = Nauto,
@pub_identity_range = 10000,
@identity_range = 1000,
@threshold = 80,
@destination_table = Nпосещение,
@destination_owner = Ndbo,
@status = 24,
@vertical_partition = Nfalse,
@ins_cmd = NCALL [dbo].[sp_MSins_dboпосещение],
@del_cmd = NVCALL [dbo].[sp_MSdel_dboпосещение], @upd_cmd = NVCALL [dbo].[sp_MSupd_dboпосещение][kp_bd]_addarticle
@publication = Npub1,
@article = Nрасписание, @source_owner = Ndbo,
@source_object = Nрасписание,
@type = Nlogbased, @description = N,
@creation_script = N,
@pre_creation_cmd = Ndrop, @schema_option = 0x0000000008035CDF,
@identityrangemanagementoption= Nauto, @pub_identity_range = 10000,
@identity_range = 1000,
@threshold = 80,
@destination_table = Nрасписание,
@destination_owner = Ndbo,
@status = 24,
@vertical_partition = Nfalse,
@ins_cmd = NCALL [dbo].[sp_MSins_dboрасписание],
@del_cmd = NVCALL [dbo].[sp_MSdel_dboрасписание],
@upd_cmd = NVCALL [dbo].[sp_MSupd_dboрасписание][kp_bd]_addarticle
@publication = Npub1,
@article = Nрецепт, @source_owner = Ndbo,
@source_object = Nрецепт,
@type = Nlogbased, @description = N,
@creation_script = N,
@pre_creation_cmd = Ndrop, @schema_option = 0x0000000008035CDF,
@identityrangemanagementoption = Nauto,
@pub_identity_range = 10000,
@identity_range = 1000,
@threshold = 80,
@destination_table = Nрецепт,
@destination_owner = Ndbo,
@status = 24,
@vertical_partition = Nfalse,
@ins_cmd = NCALL [dbo].[sp_MSins_dboрецепт],
@del_cmd = NVCALL [dbo].[sp_MSdel_dboрецепт], @upd_cmd = NVCALL [dbo].[sp_MSupd_dboрецепт][kp_bd]_addarticle
@publication = Npub1,
@article = Nсмена,
@source_owner= Ndbo,
@source_object = Nсмена,
@type = Nlogbased,
@description = N,
@creation_script = N,
@pre_creation_cmd = Ndrop,
@schema_option = 0x0000000008035CDF,
@identityrangemanagementoption = Nauto, @pub_identity_range = 10000,
@identity_range = 1000,
@threshold = 80, @destination_table = Nсмена,
@destination_owner = Ndbo,
@status = 24, @vertical_partition = Nfalse,
@ins_cmd = NCALL [dbo].[sp_MSins_dboсмена], @del_cmd = NVCALL [dbo].[sp_MSdel_dboсмена],
@upd_cmd = NVCALL [dbo].[sp_MSupd_dboсмена][kp_bd]_addarticle
@publication = Npub1,
@article = Nспециальность, @source_owner = Ndbo,
@source_object = Nспециальность,
@type = Nlogbased, @description = N,
@creation_script = N,
@pre_creation_cmd = Ndrop,
@schema_option = 0x0000000008035CDF,
@identityrangemanagementoption= Nauto,
@pub_identity_range = 10000,
@identity_range = 1000,
@threshold =80,
@destination_table = Nспециальность,
@destination_owner = Ndbo, @status = 24,
@vertical_partition = Nfalse,
@ins_cmd = NCALL [dbo].[sp_MSins_dboспециальность],
@del_cmd = NVCALL [dbo].[sp_MSdel_dboспециальность],
@upd_cmd = NVCALL [dbo].[sp_MSupd_dboспециальность][kp_bd]_addarticle
@publication = Npub1,
@article = Nтип_посещения, @source_owner = Ndbo,
@source_object = Nтип_посещения,
@type = Nlogbased,
@description = N,
@creation_script = N,
@pre_creation_cmd = Ndrop,
@schema_option = 0x0000000008035CDF,
@identityrangemanagementoption= Nauto,
@pub_identity_range = 10000,
@identity_range = 1000,
@threshold = 80,
@destination_table = Nтип_посещения,
@destination_owner = Ndbo,
@status = 24, @vertical_partition = Nfalse,
@ins_cmd = NCALL [dbo].[sp_MSins_dboтип_посещения],
@del_cmd = NVCALL [dbo].[sp_MSdel_dboтип_посещения],
@upd_cmd = NVCALL [dbo].[sp_MSupd_dboтип_посещения][kp_bd]_addarticle
@publication = Npub1,
@article = Nулица,
@source_owner= Ndbo,
@source_object = Nулица,
@type = Nlogbased,
@description = N, @creation_script = N,
@pre_creation_cmd = Ndrop,
@schema_option= 0x0000000008035CDF,
@identityrangemanagementoption = Nauto, @pub_identity_range = 10000,
@identity_range = 1000,
@threshold = 80, @destination_table = Nулица,
@destination_owner = Ndbo,
@status = 24, @vertical_partition = Nfalse,
@ins_cmd = NCALL [dbo].[sp_MSins_dboулица], @del_cmd = NVCALL [dbo].[sp_MSdel_dboулица],
@upd_cmd = NVCALL [dbo].[sp_MSupd_dboулица][kp_bd]_addarticle
@publication = Npub1,
@article = Nучасток,
@source_owner = Ndbo,
@source_object = Nучасток,
@type = Nlogbased,
@description = N,
@creation_script = N,
@pre_creation_cmd = Ndrop,
@schema_option = 0x0000000008035CDF,
@identityrangemanagementoption = Nauto,
@pub_identity_range = 10000,
@identity_range = 1000,
@threshold = 80,
@destination_table = Nучасток,
@destination_owner = Ndbo, @status = 24,
@vertical_partition = Nfalse,
@ins_cmd = NCALL [dbo].[sp_MSins_dboучасток],
@del_cmd = NVCALL [dbo].[sp_MSdel_dboучасток], @upd_cmd = NVCALL [dbo].[sp_MSupd_dboучасток]
- Добавление подписок на публикацию транзакций[kp_bd]_addsubscription
@publication = Npub1,
@subscriber = NREDWHITE-ПК\MSSQLSERVERSERJ2,
@destination_db = Nkp_bd, @subscription_type = NPull, @sync_type = Nautomatic,
@article = Nall,
@update_mode = Nfailover,
@subscriber_type = 0
- Добавление транзакционной подписки по запросу
/****** Начало: сценарий для запуска на подписчике ******/[kp_bd]exec sp_addpullsubscription
@publisher = NREDWHITE-ПК\MSSQLSERVERSERJ1,
@publication = Npub1,
@publisher_db = Nkp_bd,
@independent_agent = NTrue,
@subscription_type = Npull,
@description = N,
@update_mode = Nfailover,
@immediate_sync = 1
/*Задает сведения о конфигурации и безопасности, применяемые триггерами --синхронизации немедленно обновляемых подписок при подключении к издателю. Эта хранимая процедура выполняется на подписчике в базе данных подписки.*/_link_publication
@publisher = NREDWHITE-ПК\MSSQLSERVERSERJ1,
@publication = Npub1,
@publis