Formatting help

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

Formatting help

Postby CraigRichards » Wed Aug 04, 2010 12:39 am

Does anyone know how to get the following formatting to work?

From
IF EXISTS ( SELECT TOP 1
1
FROM
inserted )
IF EXISTS ( SELECT TOP 1
1
FROM
deleted )
/*Update Block*/

To
IF EXISTS ( SELECT TOP 1 1 FROM inserted )
IF EXISTS ( SELECT TOP 1 1 FROM deleted )

AND
This
FROM
deleted
INNER JOIN INSERTED
ON DELETED.PeopleId = INSERTED.PeopleId

to
FROM deleted
.INNER JOIN INSERTED
ON DELETED.PeopleId = INSERTED.PeopleId

Thanks all
CraigRichards
 
Posts: 1
Joined: Wed Aug 04, 2010 12:35 am

Postby Anu Deshpande » Thu Aug 05, 2010 9:19 am

Many thanks for your post.

We have logged two support calls for you F0037421 and F0037422.
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