Try this:

CREATE FUNCTION dbo.fnTest ()

RETURNS int

WITH SCHEMABINDING

AS

BEGIN

RETURN 1

END

GO

I disagree. To answer...

Toreador (11/17/2009)

---

Ah, that old chestnut.

I've never been Prime Minister either, but I still get to say what I...

Daniel Wood (11/17/2009)

---

Thanks for the replies

More information

Buffer cache Ratio seems to be 90 - 96

There is also an issue with high IO on the data drive which the System team...

Toreador (11/17/2009)

---

Lynn Pettis (11/17/2009)

---

Yes, getdate() and getutcdate() return different values, just look at what they return when you run them. However both functions return values that are equivelent to...

ARRRRGGGGGG!!!!

I'm heading out to the desert for a while just in case you don't see me for a few days.

david.j.campbell (11/17/2009)

---

You on the same longitude as Greenwich England, Bitbucket?

This is the first time I can think of that I've been discriminated against based on my geography.

While the values may...

Okay, I give up. No one is really paying attention to the concept that the question was trying to bring out. Everyone is concentrating on the actual values...

Cliff Jones (11/17/2009)

---

I work with date time functions all of the time and would contend that since the Time Zone is not returned as part of the result, the times...

7:00 AM <> 2:00 PM, true

7:00 AM MST = 2:00 PM UTC, true.

That is the concept that the question is trying to address.

Been there, done that in other areas. Not a biggie.

😉

Bru Medishetty (11/17/2009)

---

You can start with a Weekly Full backup and daily Differential backup (if needed twice a day).

Monitor the Database growth over a few weeks period, and then decide...

Good catch, yes that should be a left outer join. Not enough "coffee" this morning. Getting into work at 6:00 AM local time starting this week and obviously...

Actually, the seconds are...

cengland0 (11/17/2009)

---

Lynn, you have a valid point but if you were to show those times to a client, they would only see the output not the representation. So, for...