I just follow my gut. Sometimes I just get feelings of trust or distrust from people...

In fact there is only one group of people that I instantly distrust, regardless...

As someone who has had no formal training on SQL Server of any version and was dumped into the DBA world by the business, I can say that the maintenance...

Would I go back to Uni and get my degree (in computing that is)? Short answer, no.

I have seen the type of stuff the local University is teaching in...

Andy Lennon (6/12/2009)

---

i regret not taking a year break after High School before going to college.

...

I didn't think about it at the time but i was flat out sick...

Cool, thanks for that.

so yeah, at the end of the day it comes back to the old "Acceptable Risk" guideline.

And if I was storing anything so secret that I had...

And that is exactly why I cringe at the word 🙂

Especially when it is your franchisor...

Utopia - Also in a software perspective (We are progressing our software to a utopia)

I get chills every time I hear it.

and apparently is considered insecure (MSDN Link) along with the other MD hashes. SHA is apparently the way to go instead.

Of course I don't really play in that space so...

Well, I wouldn't say behind me, but the direction of my work is slowly shifting, not by design either, it just kind of creeps up on you.

Not that surprising for...

Don't forget to set the initial value of @val to -1 before each pass, you won't get the correct answers if you don't.

-d

"Don't bother with that complicated outer join, just use the IN keyword"

that's what I meant 🙂

i probably shouldnt have used the term multiple choice by itself since that isnt implicit enough.

I did mean it wasnt a single answer multiple choice.

aah well...

i wouldnt use PRINT to test it, it doesnt handle NULL's well.

And dont run every option in the same pass, it will muck up your results. If you want...

There is.

SET ANSI_NULLS OFF

the reason it is not recommended is because as the name of the variable suggests, you are turning off an ANSI standard which can lead to compatibility...

EDIT: Don't get me wrong, the question is great. It applies to MS Access also. NULL is always screwing up my queries. I often wish the DB...