Activity overview
Latest activity by Edmund
Visual Studio 2010 Database Project not using SQL Prompt Pro
Hi all,
Visual Studio 2010 (10.0.30319.1 RTMRel) has the SQL Prompt 5 (5.1.8.2) menu item. I created a VS 2010 Database Project and pulled in my development database. I've connected the project to ...
Smart Rename: TRY ... CATCH,
Good day Red Gate,
I'm looking into using the Smart Rename feature to change the schema of a few objects and have all the dependent objects updated. They are a few base objects that are used in ma...
Hi chrisk5,
Things format a little better with the recomendation you provided. The following
SELECT P.NAME AS Parent, C.NAME AS Child
FROM dbo.ListOfThings P --Parent
JOIN dbo.ListOfThings C --Child
ON P.NAME = C.Parent
now formats to
SELECT P.NAME AS Parent, C.NAME AS Child
FROM dbo.ListOfThings P --Parent
JOIN dbo.ListOfThings C --Child
ON P.NAME = C.Parent
.
The commet stays on the same line but ON condition is indented. However, I can't use that option as I need the join condition on a new line in locations where there is no table alias comment and the join condition is currently on the same line.
I guess the good news is that this is a known issue. As I understand this thread there is no fix for this currently but it will be addressed in the next update of SQL Prompt. Correct?
Thanks,
Edmund / comments
Hi chrisk5,
Things format a little better with the recomendation you provided. The following
SELECT P.NAME AS Parent, C.NAME AS Child
FROM dbo.ListOfThings P --Parent
JOIN dbo.ListOfThings C -...
Hello chrisk5,
I get the same result. The following SELECT P.NAME AS Parent, C.NAME AS Child
FROM dbo.ListOfThings P --Parent
JOIN dbo.ListOfThings C --Child
ON P.NAME = C.Parent
still is formated to this SELECT P.NAME AS Parent, C.NAME AS Child
FROM dbo.ListOfThings P --Parent
JOIN dbo.ListOfThings C
--Child
ON
P.NAME = C.Parent
with the imported style you provided.
Edmund / comments
Hello chrisk5,
I get the same result. The followingSELECT P.NAME AS Parent, C.NAME AS Child
FROM dbo.ListOfThings P --Parent
JOIN dbo.ListOfThings C --Child
ON P.NAME = C.Parent
still is fo...
SSMS: 10.50.1600.1
SQL Prompt Pro: 5.1.4.11 / comments
SSMS: 10.50.1600.1
SQL Prompt Pro: 5.1.4.11
[Format SQL] Odd Behaviour with Table Alias Comment
Hello Red Gate,
I've recently installed SQL Prompt Pro and have noticed that Format SQL behaves oddly when table alias comments are present. For example,
SELECT P.NAME AS Parent, C.NAME AS Child
F...