select
* from replicare pe receptor nu imi returneaza nimic deci nu sunt mesaje in coada.
Asta este procedura care se activeaza cand intra un mesaj in coada
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;
;
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
end conversation @conversation
END
Secolul XXI ori va fi religios ori nu va fi deloc