Brandie Tarvin (7/23/2014)

---

Not to provoke debate (but I'm gonna anyway @=), I generally use surrogate Identity columns as singular, non-composite PKs because if I used natural composite keys, I'd be...

Dosh

I appear to have clicked an answer that I was sure I didn't click. I guess that didn't happen, so it ust have been finger trouble. I agree...

I think that this is a pretty good question. But asking which answer is "most correct" is asking for a judgement call, rather than just for knowledge of a...

No, he didn't do...

I rather agree with Patrick's comment above - but I read the rubbish and got steadily more appalled as I went through it. A (Python) Programmer is apparently the...

Brandie Tarvin (7/23/2014)

---

Grant Fritchey (7/23/2014)

---

Brandie Tarvin (7/23/2014)

---

There are people who will disagree with me on this, but I have found adding an IDENTITY (1,1) column to the table and adding...

Good question (but a pity about the unwanted editing).

I almost fell for the collation error on skim reading the code, but on looking mor carefully because that seemed too easy...

Good question.

My brain's not working tonight - I picked one option and forgot to pick a second. It must be the red wine.

Bad question. The answer depends on what privileges you are logged in with. Telling people the correct answer is that you can do this is encouraging them to...

pankaja_us (7/21/2014)

---

The second query

select *

from testdata

where productname like searchpattern escape EscapeClause

is returning to me just one row... I tested the whole code block in the question... care...

Eirikur Eiriksson (7/18/2014)

---

Must admit that I fear the same, almost like there is no comprehention what...

You haven't said what fails in SSIS nor what works in SSMS. So...

If you change the key you can't decrypt information that was...

Welsh Corgi (7/18/2014)

---

I'm having a weird problem.

I do not have it in one AS400 Library within SSIS but when I go to another I get an error that the column...