thank you Antony. (yes, R2 is different, 2008 and 2008 R2 needs to be treated as two different things)

Sorry for this off-topic question.

I just installed SP1 on the vmbox running SQL 2008 R2 and can see these objects accessible.

Just wanted to know, now I see that SP2...

Thank you Keon.

anthony.green (2/24/2012)

---

Raghavendra Mudugal (2/24/2012)

---

SQL Version

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Express Edition...

SQL Version

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Express Edition with Advanced Services...

YAY!!!. I got one point.

(representation of N - has nothing to do with the collation)

I selected "NO and NO" 🙁

NoteToSelf: When it says R2 then refer only the R2-BOL. Referring 2005-BOL will not help.

I have seen saying that using NOLOCK is good sign of the poor design.

In my current work, we use NOLOCK in all SQL statements, (I know its not good)

from the...

SathishK (2/10/2012)

---

Raghavendra Mudugal (2/10/2012)

---

cengland0 (2/10/2012)

---

Raghavendra Mudugal (2/10/2012)

---

cengland0 (2/10/2012)

---

Steve Jones - SSC Editor (2/9/2012)

---

SELECT HASHBYTES( 'SHA1', 'R@nd0m' + Pwd + firstname)

FROM Employees

In this case, without access to the code, it...

cengland0 (2/10/2012)

---

Raghavendra Mudugal (2/10/2012)

---

cengland0 (2/10/2012)

---

Steve Jones - SSC Editor (2/9/2012)

---

SELECT HASHBYTES( 'SHA1', 'R@nd0m' + Pwd + firstname)

FROM Employees

In this case, without access to the code, it becomes hard to...

cengland0 (2/10/2012)

---

Steve Jones - SSC Editor (2/9/2012)

---

SELECT HASHBYTES( 'SHA1', 'R@nd0m' + Pwd + firstname)

FROM Employees

In this case, without access to the code, it becomes hard to determine what the...

0xB9A02E529093456D139C69FC5E5D4D825B7EC24B0xCDE457DD8AB6C020E9852FE5B6953E02631A2CB2

this is the output of your query, just wanted to know what you mean by "exact same results"....?

For me this question did not made any sense.

the sample code is just concatenating another variable to it, you can name it @salt to @sugar... still the sample code will...

To be honest, I took the article by very surprise.

Currently I am working as an Application Support (IT section) in a Shipping company. From the 6.5 to 2012...

G'Day! Bert!

Thanks a lot.