Jean-Sebastien Carle (10/31/2009)

---

Generally speaking, IP addresses exist within a database as a result of logging. The logging will often cumulate over time to generate hundreds of thousands if not millions...

Darren Wallace (9/9/2009)

---

Andrew (9/9/2009)

---

rja.carnegie (9/9/2009)

---

I mean, have I got this wrong: I can change your password to what I want it to be. But I can't change it back,...

rja.carnegie (9/9/2009)

---

I mean, have I got this wrong: I can change your password to what I want it to be. But I can't change it back, or can I?...

Hopefully DBAs would be much more careful, but as I read this I was reminded of all the jobs I've had where a supervisor had to enter verification (via a...

I like this format as well, since that's essentially what IP addresses are anyway. Like using...

@michael-2 - I like the output, but the documentation syntax itself is so verbose! It looks like 60% of the time you spend typing a procedure could easily...

The extended properties work OK for documentation -- if EM/SSMS is your documentation framework. ::cringing:: :ermm:

They are a pain to enter, but there are tools out there that read them...

Richard Briggs (3/13/2009)

---

Andrew (3/13/2009)

---

Perhaps, but everyone isn't born at midnight...

Perhaps, but everyone isn't born at midnight either, so you...

Richard Briggs (3/13/2009)

---

Comrades,

as regards my own post on creating a CALCULATED PERSISTED column containing 'Age'.

I have discovered that actually because GetDate() is non-deterministic such a column cannot be made to...

Prashant (3/13/2009)

---

ok What about the following?

DECLARE @BirthDate datetime

DECLARE @CurrentDate datetime

DECLARE @Age int

SET @BirthDate = '2008-03-13 10:10:00' /* OR Whatever date you want */

SET @CurrentDate = GETDATE() /* OR Whatever date...

roger.plowman (8/28/2008)

---

As far as windmills being green, well, not so much. Apparently there are problems with bats as well as birds, apparantly bats' lungs explode in the low pressure areas...

You are making sense, but I don't see how you'd do it. Any update query you run will update all the rows that have the same values for all three...

You weren't the only one to make either of those mistakes. I see several contributors stuck in the same tar pits over the last 7 pages of comments.

Andrew

Another [implicit] rule is that the solution should return the desired result. While I don't understand the...