Welcome to Sign in | Help

Re: Sincronizare SQLServer Express

  •  08-31-2007, 3:48 PM

    Re: Sincronizare SQLServer Express

    Am creat pe receptor o tabela cu doua coloane msg xml si msgtyoe nvarchar(10)

    AM comentat inserturile alea,si am pus sa-mi insereze in tabela asta mesgtype si msg care le primeste,si am null imi insereaza de fiecare data cand trimit un mesaj un rand null.

    Asta e codul proceduri de activare

    ALTER PROCEDURE [dbo].[repl_insert]

     

    AS

    BEGIN

    -- SET NOCOUNT ON added to prevent extra result sets from

    -- interfering with SELECT statements.

    declare @conversation uniqueidentifier

    declare @msg xml,@msgtype nvarchar(128)

    SET NOCOUNT ON;

    begin transaction

    ;receive top(1) @conversation=conversation_handle,@msgtype=message_type_name,@msg=message_body from replicare

    --if (@msgtype='insertie')

    --insert into tbl_boy select * from boys(@msg)

    -- -- Insert statements for procedure here

    --else

    --insert into tbl_boy values(@msgtype,-1,-1)

    insert into mesaje values(@msg,@msgtype)

    commit

    end conversation @conversation

    END

    Nu-mi dau seama care e buba Sleep


    Secolul XXI ori va fi religios ori nu va fi deloc
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems