That's...

The data is being cached in client end, but for first time login and if the cache is cleared, it will be problem.

I think for auto-complete to work effectively, the...

This proc will be called for auto-complete feature and while typing each character it will be called. The context will be set based on a dropdown value. Initially I thought...

Good question, though I answered wrong!:(

Hugo Kornelis (2/15/2012)

I got it right, for all the wrong reasons.

The script will not run, regardless of triggers, for two reasons:

1. The MERGE statements must be terminated with a semicolon....

Learnt something new, though I answered wrongly...

Nice one

Seems the database would have two columns. One for Salt and one for HashedPassword. Then, you have your application do the hashing with the RANDOM salt. You...

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 becomes...

sknox (2/10/2012)

---

BTW, now that I am posting anyway - there is one word in the explanation is wrong: "The query optimizer in lower editions will only consider the indexed view...

sknox (2/10/2012)

---

Hugo Kornelis (2/10/2012)

---

I hate questions where I have to second-guess the author. Did the author mean that the optimizer would choose to use the indexed view automatically? Or did...

Thanks for the question and like the answer options very much 🙂

---

Good Question, but "Add the sale string" seems to be tricky... 🙂

It took around 2 hours for me to solve it and finally got it right 🙂

Ofcourse, learnt something new

Great question... Is that mean when any object with SP_ prefix used in combination with if (as in this case) would be searched in the current DB first and then...