Are the questions getting too easy?

Nice question, but the answer is a bit too obvious, I think.

Are the questions getting too easy?

Nice question, but the answer is a bit too obvious, I think.

Roy Ernest (9/4/2014)

---

So ANSI Joe is still at it? It has been a very long time since I have been to the forums.

Do we have any new ANSI Joe...

Jeff Moden (9/3/2014)

---

Again, Gail will already know the reason for the performance boost in the second While Loop. I'm probably not using the right terminology but the simple explanation...

Museli

Good analysis, Hugo, but personally I regard terminating "begin" as an abomination - after all, it is not a statement but a bracket indicating that a compound statement begins here....

Nice clear question.

It's also a neat demonstration of how idiotic it was to use rge word "with" to introduce a CTE definition. There were other possibilities, some of them...

ScottPletcher (9/3/2014)

---

LutzM (9/3/2014)

---

ScottPletcher (9/3/2014)

---

...

There are 3rd party solutions that do that, but they are rather expensive. At least one we investigated uses its own "black box" to hold the...

ScottPletcher (9/3/2014)

---

Triggers can capture the originating user as well if you provide that info to the trigger. This can be passed in several ways, including CONTEXT_INFO, APP_NAME or even...

Gates

Actually I reckon the NPA people should have been Joe and...

That's downright appalling....

Seems...

palotaiarpad (9/3/2014)

---

I thought it'd fail at:

CREATE PROCEDURE [TEST].[PopulateAddress] (@Address AS TVP.Address READONLY)

BOL has no reference to this 'AS':

[ { @parameter [ type_schema_name. ] data_type }

...

Luis Cazares (9/3/2014)

---

xsevensinzx (9/3/2014)

---

Koen Verbeeck (9/3/2014)

---

xsevensinzx (9/3/2014)

---

I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to...