Activity overview
Latest activity by schaitel
I don't know what all the big deal is. I don't know any SQL Developers who uses Visual Studio for SQL development. We all use Enterprise Manager, Query Analyzer or SQL Management Studio. I think you folks who use VS are a minority. I don't think you should give Red-Gate a hard time about it. / comments
I don't know what all the big deal is. I don't know any SQL Developers who uses Visual Studio for SQL development. We all use Enterprise Manager, Query Analyzer or SQL Management Studio. I think yo...
Will you be offering a pre-order discount like you did for Prompt 3.0? / comments
Will you be offering a pre-order discount like you did for Prompt 3.0?
Refactoring other people's code
I have been using Refactor quite a bit lately, usually to make code written by others before me conform to my standard layout. One feature I would like to see is to help standardize SQL, although i...
I could not find a way to keep the column list on GROUP BY and ORDER BY on their own lines. It currently changes my code to this:
select sum(sp.qty) as qty
, e.territory_number
from sample_product sp
join enrollment e on sp.nah_customer_id = e.nah_customer_id
where sp.tracking_form_date >= '2006-1-9 00:00:00.000'
group by
e.territory_number
order by
e.territory_number
But I would like to have the columns on the group by and order by columns on the same line as the reserved word. I also wish the JOIN statement would line up with SELECT, FROM, WHERE, GROUP BY and ORDER BY. I cannot understand why it is indented. Perhaps I am missing something.
select sum(sp.qty) as qty
, e.territory_number
from sample_product sp
join enrollment e on sp.nah_customer_id = e.nah_customer_id
where sp.tracking_form_date >= '2006-1-9 00:00:00.000'
group by e.territory_number
order by e.territory_number / comments
I could not find a way to keep the column list on GROUP BY and ORDER BY on their own lines. It currently changes my code to this:
select sum(sp.qty) as qty
, e.territory_number
from sampl...
I like SQL Refactor alot better than SQL Pretty Printer, but one feature that SQL Pretty Printer has that this Beta of Refactor doesn't (and I hope is added!) is the ability to transform code to either UPPERCASE, LOWERCASE or PROPERCASE. I like to set my SQL reserved words to upper case, my identifiers to lower case and functions to proper case (or as it calls it InitCase).
So it takes code like this:
select firstname from customer where insertdate = getdate()
and makes it look like this:
SELECT firstname
FROM customer
WHERE insertdate = Getdate() / comments
I like SQL Refactor alot better than SQL Pretty Printer, but one feature that SQL Pretty Printer has that this Beta of Refactor doesn't (and I hope is added!) is the ability to transform code to ei...