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

Someone revived this thread again today after another two years. But I think I might as well throw my bit in anyway, so that someone who comes here...