autoexcrement (4/18/2013)

---

Thanks, I love your replies. 🙂 Few questions, if you have time...

1) What do you mean by suggesting triggers on the view? I didn't know triggers could have anything...

Good question, and an excellent explanation apart from the point raised by Christian. I don't think the comments are misleading, it is pretty common for a comment to be...

autoexcrement (4/18/2013)

---

Thanks for weighing in. My concern is just that if I create a "master" record in "people" and use their "real name" in that table, what's to prevent that...

prathibha_aviator (4/18/2013)

---

My requirement is to

-Get the value stored...

patrickmcginnis59 10839 (4/18/2013)

---

dbursey (4/18/2013)

---

From the other side of the fence - I've asked questions here and got ripped a new one because I didn't provide actual examples - sometimes it's...

Looks as if there was a good idea but it was rather poorly executed. The query won't return 3 rows each with 1 column, but 6 rows each with...

krishnavenkat16 (4/16/2013)

---

Hey Tom,

Here what i'm getting....

for insert...new records are logged - with this requester can know what record is inserted

for update....old records are logged - with this Requester will know...

Do you think a zero length string contains a character which isn't in 0 to 9? Or that...

Lowell (4/16/2013)

---

unlike all of you guys who completed all their tax paperwork in January and already got your refunds back, my yesterday was

non stop juggling of funds so I could...

Actually with that code you are...

The problem...

You commented the code that does that out:

if @optype = 2 --or @optype = 3

the...

Nice question, but as only one list of values ended with 0 it was easy to get the answer without checking anything else, so much easier than it looked at...

As welll as what Lowell says, you need to distinguish between the three possible causes of entering the trigger: Insert, update, and delete. Also, if you are signalling unexpected...

Hugo Kornelis (4/15/2013)

---

Calling a column ID and then putting duplicate values in it is just evil. No raise for the developer who wrote this, and a warning that (s)he'll be...