SQL-Prompt Professional layout Merge statement

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

SQL-Prompt Professional layout Merge statement

Postby bauerju » Wed Nov 19, 2008 11:33 am

Hi
I'am using SQl-Prompt 3.9.0.43 on SSMS 2008 with SqlServer 2008 and have problems with the new MERGE-statement.

Layout and candidate listing don't work:
for example:
DECLARE @T1 TABLE ( Tab1 INT,TAb2 INT )
DECLARE @T2 TABLE ( Tab1 INT,TAb2 INT )
MERGE @T1 S USING @T2 D ON S.Tab1 = D.Tab1 WHEN MATCHED THEN UPDATE SET Tab2 = d.Tab2 WHEN NOT MATCHED THEN INSERT ( Tab1,TAb2 ) VALUES ( d.tab1,d.tab2 ) ;


It should be layoutet like
MERGE @T1 S
____USING @T2 D
________ON S.Tab1 = D.Tab1
____WHEN MATCHED THEN
________UPDATE
____________SET Tab2 = d.Tab2
____WHEN NOT MATCHED THEN
________INSERT ( Tab1,TAb2 )
____________VALUES ( d.tab1,d.tab2 ) ;


What can I do?

Jürgen
bauerju
 
Posts: 5
Joined: Fri Apr 18, 2008 1:13 pm

Postby Anu Deshpande » Wed Nov 17, 2010 2:29 pm

Many thanks for your post.

Latest patch for SQL Prompt 3 will fix the issue SQL Prompt not prompting MERGE in candidate list and the formatting issue is fixed in SQL Prompt 4.

If you email us your serial number I can find the best option for you.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests