finally a ,ers se insereaza
asta e codul castigator
begin
transaction
;
receive top(1) @conversation=conversation_handle,@msgtype=message_type_name,@msg=message_body from replicare
select
@msgtype
select
@msg
if
(@msgtype='insertie')
begin
exec
sp_xml_preparedocument @idoc output,@msg
insert
into tbl_boy select * from openxml(@idoc,'/boys/boy') with (FirstName varchar(20),Counter int,Year int,id int)
exec
sp_xml_removedocument @idoc
end
-- Insert statements for procedure here
--else
--insert into tbl_boy values(@msgtype,-1,-1)
--insert into mesaje values(@msg,@msgtype)
commit
end
conversation @conversation
Inca o intrebare la contractul respectiv vreau sa ma adaug doua tipuri de mesaje stergere si actualizare ca sa fac replicarea complet.
AM vazut ca nu am alter contract cum pot face asta trebuie neaparat sa creez contractul dinnou?
Multumesc
Secolul XXI ori va fi religios ori nu va fi deloc