Sorry, I forgot to say

The builtin/administrators login is still in place

My SQL Server doesn't login using local system or Administrator, but uses a made Admin level account

Enterprise Manager creates a temporary table, inserts all of the records, drops the original table and then renames the temp table when you add in the middle

It shouldn't make any difference...

The funny thing is that I executed the query with no warning...

No there isn't, they're exactly the same

Option 2:

UPDATE FORUM_MEMBERS

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

WHERE M_EMAIL LIKE '%@abc.com'

Option 3:

UPDATE FORUM_MEMBERS

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

WHERE M_EMAIL LIKE '%@abc.com'

Option 1 has...

After some testing, I've taken a "sideways" step on this

I've added fields to the main table, then run Triggers on the sub-tables that update the main table

Query is now about...

Oops, I posted about the wrong field name in the 15th thread

Oh well, at least they've got it sorted on the site

I know it returns a single result set, but for speed purposes, are they a good idea?

I've not done too much testing as I know it can make a big...

All of the solutions are wrong - the ORDER BY parts have the wrong field name, they have "articleid" when the description clearly states "article_id"

Picky, maybe, but they are wrong...

...

That is PERFECT

I don't know why I didn't think to put that in the FROM... I tend to think in WHERE's 🙂

Thank you!

That works PERFECTLY

I tried using EXEC() on the ALTER TABLE, but not on the SELECT

It takes around half a second when it's doing an update, but that's acceptible as it...

quote:

---

As a side note, columns of type BIT cannot be null; you can only add one without a default value if the...

Oops, this is my other login, using a different email address

Forgot I was logged in using this one

I would love to do that, but I'm using ColdFusion and CFQUERY, and if I use GO it "spits"

Maybe I should turn it into a Stored Procedure and pass it...