Hugo Kornelis (10/27/2010)

---

Is that becuase of the...

I am not certain. Are they? :w00t:

I just used your response as a jumping off point.

I know you are not...

Michael Valentine Jones (10/27/2010)

---

Toreador (10/27/2010)

---

Hugo Kornelis (10/27/2010)

---

print 'Format mdy'

set dateformat mdy

select x1 =convert(datetime,'2010-12-31')

go

print 'Format ymd'

set dateformat ydm

select x2=convert(datetime,'2010-12-31')

Results:

Format mdy

x1

------------------------

2010-12-31 00:00:00.000

(1 row(s) affected)

Format ymd

Server: Msg 242, Level 16, State 3, Line...

Hugo Kornelis (10/27/2010)

---

SanDroid (10/27/2010)

---

da-zero (10/27/2010)

---

These questions should provide a learning opportunity, and that will hardly happen with questions as simple as this one. I expect the QotD to be about...

I can tell by your reading and writing level you might be the moderator checking the...

I give this question Five Stars!

It was code correct, the question was clear and had no typo's, and the author clearly understood the concept his question was testing.

This Question of...

Mayank (10/26/2010)

---

Normally to enable the Broker Service, you need to simply use : "ENABLE_BROKER"

But when you restore the back up of database db1 to database db2, and after that if...

I really hope you are joking. ...

One that supports RDMS management and Administration.

It can take up to 3 hours to transactionaly Delete and...

Hyperdata (10/12/2010)

---

This is the business case for GUIDs that I believe make the use appropriate.

Last year I spent three months on such a case. That work...

e3h4 (10/12/2010)

---

People often assume you need to use GUIDs for unique values across databases and for replication. However, there is an easy way to get around that using an...

How could I have been so stupid to think we were talking about...

This explains why a person should use a UUID in application development.

That is...

David Walker-278941 (10/12/2010)

---

OK, well, I see that we disagree. People who are smarter than I am (who write books on the guts of SQL, for example) also like GUIDs....

dwinters 67194 (10/12/2010)

---

As a consultant I find myself constantly coming in behind folks and fixing designs that try to only work with identity, int, or char keys when a GUID...