Current .Net Version: 2.0.50727
(select below)
.Net Framework
ADO.NET
ASP.NET/Web Forms
C#
Certifications
SQL Server
Visual C#
Windows Forms
XML Web Services
Mike's C#, VS.NET and SQL Blog
T-SQL Scripts
RECEIVE
-- Tested with SQL Server 2005 9.00.852 -- Retrieves the next available set of -- dialog conversation messages from the queue. USE DotNetFun; DECLARE @InProcTable TABLE ( conversation_handle UNIQUEIDENTIFIER, message_body VARBINARY(MAX)); -- Insert each message body from each message into -- an in-memory table: RECEIVE conversation_handle, message_body FROM DotNetFun..DotNetFunQueue INTO @InProcTable; /* NOTE: With RECEIVE, Service Broker retrieves messages one conversation group at a time. */
Open/Save
|
E-mail
|
Back
COPYRIGHT/DISCLAIMER
|
CONTACT US
Current .Net Version: 2.0.50727
Current .Net Version: 2.0.50727
