I stumbled across this abandoned post today while attempting to address the same issue, and thought I'd update it with my conclusion: It's simply not possible to specify the "OPTION...

Chris.C-977504 (7/19/2012)

---

The power of ten makes it better?

Then why wasn't there a push to have a day sliced into 10 hours, an hour sliced into ten minutes, and a...

OK, I didn't understand the reference the first time, but now...

GSquared (7/19/2012)

---

Tao Klerks (7/19/2012)

---

Lynn Pettis (7/19/2012)

---

Two, on this "The Imperial system works; the metric system works better", whose definition of better? What makes it better? Or is it...

Lynn Pettis (7/19/2012)

---

Two, on this "The Imperial system works; the metric system works better", whose definition of better? What makes it better? Or is it just easier to...

paul.knibbs (7/19/2012)

---

I'm pretty sure that farmers themselves don't give half a monkey's for DST--they structure their day around the rising and setting of the sun, and what direction the hour...

SQLBill (7/17/2012)

---

GETDATE() returns the server time. That...

The naming's not exactly what you're asking for, but the function exists:

SELECT GetUTCDate()

You are of course right that working with dates in T-SQL could be much easier, but the example you propose cannot work correctly, in any system, ever:

DECLARE

Quick update on this thread, the latest version of this formatter was published today, including Notepad++ plugin, SSMS 2012/Demali support, a couple of translations (French/Spanish), pipeline support on the command-line...

Thanks Hugo,

Great question, and between your form and Paul's I now have 2 more cases that my T-SQL formatter doesn't handle correctly; at least it's not mangling the SQL, but...

the simplest thing is to send me two things, for each situation where you'd like the result to be different:

• The original SQL, unformatted
• The SQL formatted exactly how you'd want it

You...

Tao Klerks (9/20/2011)

---

#4: Removing most of those newlines is just a question of unchecking the "Expand Comma Lists" option; the one that you won't be able to remove is the...

Thanks for the feedback gvarol!

#1: I think you can just uncheck the "Expand Comma Lists" option, or am I missing something? If you want to wrap based on a specific...

Thanks!