Options
BUG: Wrong semicolon insert. SQL Prompt 6.4.0.657
sdks
Posts: 44 Bronze 2
Mainly it is working good, but I found the case where it set incorrectly
BEGIN
BEGIN TRANSACTION;
WAITFOR
(
RECEIVE TOP (1)
@conversation_handle = conversation_handle,
@message_body = CAST(CAST(message_body AS NVARCHAR(36)) AS UNIQUEIDENTIFIER),
@message_type_name = message_type_name
FROM SBReceiveQueue;
), TIMEOUT 1000;
BEGIN
BEGIN TRANSACTION;
WAITFOR
(
RECEIVE TOP (1)
@conversation_handle = conversation_handle,
@message_body = CAST(CAST(message_body AS NVARCHAR(36)) AS UNIQUEIDENTIFIER),
@message_type_name = message_type_name
FROM SBReceiveQueue;
), TIMEOUT 1000;
Comments
Good catch! Thanks for finding this.
The latest stable build found here should fix the issue.
Let me know if this fixes it. If you find any more issues, please let us know.
Best regards,
David