Eirikur Eiriksson (8/5/2014)

---

Pretty...

Carlo Romagnano (8/5/2014)

---

A little variation:

-- this runs

DECLARE @i int = 1, @j-2 int = 2;

SET @i += 2;

SELECT @j-2 * @i

GO

-- this raises error

DECLARE @i int = 1, @j-2 int...

Greg Edwards-268690 (8/4/2014)

---

SQLRNNR (8/4/2014)

---

Lynn Pettis (8/4/2014)

---

Don't you just love people that ask for help but tell you it can't be a certain way, especially when the way the say it...

Nice simple question. The only difficulty was remembering what release the feature was introduced in, 2008 or 2008R2, and then I remembered which release Neos was upgrading to after...

SQLRNNR (8/4/2014)

---

Phil Factor (8/4/2014)

---

I'm sorry if it got scored too high, but when I ask this as part of a technical interview, it seems to stump a very large proportion...

That's a badlypossibly flawed answer. The correct...

SQLRNNR (8/3/2014)

---

Eirikur Eiriksson (8/3/2014)

---

If the appearance of the resume adds a value to it then selecting a font isn't enough. One should properly layout the document using the likes of...

Just like the others who have commented so far I think this is a good fundamental question which has ben assigned far too many points.

Jeff Moden (8/2/2014)

---

Heh... what's really cool about Grant is...

A lot more better looking than Arial and a bit easier to read too. Also tidier-looking than Lucida Sans Unicode (because...

MMartin1 (8/1/2014)

---

Its quite clear that a csv column is not only not normalised, but given the leading % in the search condition (doing a LIKE '%someTerm%' search) will create a...

Evil Kraig F (8/1/2014)

---

If you want to lock rows for the duration of a transaction from being read, or better keep anyone else from getting into the table at all...

Sauce

fregatepllada (8/1/2014)

---

... ... Create, Update and Delete SPs would work against table and I prefer this way because I could operate

with a set of...

fregatepllada (8/1/2014)

---

I usually stay shy from using ANY triggers - IMHO unless you implementing certain "JOB CREATION SCHEME". My usage of triggers was limited to populating historical tables when you...