de acord asta e codul
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 varchar(max),@msgtype varchar(10)
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)
commit
end conversation @conversation
END
Imi poti spune si mie unde am gresit te rog.
Dupa mintea mea procedura asta se lanseaza in executie cand intra ceva in coada si in momentul ala cu ;recieve eu preiau msgtyoe si msg si inserez in tabela tbl_boy pt replicare .Nu inteleg de ce receive imi returneaza null-uri la msgtype si msg -ce anume am gresit,ca nu-mi dau seama.
Multumesc
Secolul XXI ori va fi religios ori nu va fi deloc