Nakul Vachhrajani (5/6/2011)

---

Here in India, we have a saying that if a restauranter does not eat in his/her own restaurant or if a building contractor does not live in buildings...

Thanks for the Christmas gift.

I fell for it.

arnierowland (12/25/2015)

---

Try this one:

SELECT geometry::Parse('POLYGON((

4 0, 0 0, 3 2, 1 2, 3 4, 1 4, 3 6, 2 6,

4 8, 6 6, 5 6, 7 4, 5 4, 7...

Ahhhh. How cute is that...

Absolutely agree.

It's scary to think back at how much bad code I've written over the years, trying to be efficient, ignoring security entirely. Hopefully my code has been rewritten and improved.

Thanks for the script.

It covers so much more than I expected.

TomThomson (2/17/2013)

---

While this is the only way to create a view (including all the table's rows and) having an order by clause at the top level select in its definition,...

Yes, though I have never used the Percent keyword.

Boy, that's the truth. I deal with this every day. The app we use just keeps allowing them to come in.

Ha ha ha. You guys are crazy. That's a lot of "stuffing" and it's not even Thanksgiving.

kapil_kk (10/12/2012)

---

Worng qnswer is mentioned..

i think correct answer is -

UPDATE FORUM_MEMBERS

SET M_EMAIL = REPLACE(M_EMAIL,'@123.com', '@abc.com')

WHERE M_EMAIL LIKE '%@abc.com'

as we need to replace @123.com to @abc.com

example-

my id is kapil@leo.in...

It's been too long since I've worked in DTS. Totally forgot this.