Watch for schema issues as well, I seem to remember having issues with that the last time I worked with MySQL.

I'm still on SQL2000 in my production environment, but I can tell you that I used derived tables daily.

Views don't use variables. But all you'd need to do is get rid of your where in the view and use it in the referencing statement.

IE.

create view V_myView as

Select...

I guess I'm unclear on the question.

I'm assuming you're doing this with a cursor/loop and xp_sendmail?

Seems pretty straightforward if you already know how to process the table and send all...

So, to use FMTONLY, it'd be... this?

using (TextWriter tw = new StreamWriter("c:\\metadata.txt"))

...

Maria,

You might also take a look at this thread, which shows another application of the quirky update and compares it to other methods.

http://www.sqlservercentral.com/Forums/Topic789373-8-1.aspx

While a lot of it might...

Stopping to think about this for a few, I realized I could just select each UID (Yeah, the table has a UID already, and it's NOT the field used to...

[Edit] Nevermind, apparently I never actually stopped to think about this one, it wasn't really a difficult problem.

GSquared (9/30/2009)

---

It would be trivially easy to do that in SQL 2005, with the Output clause that added.

For SQL 2000 (which is the forum you posted in, so I assume...

The comments about the cursor/complicated TVF are true, and if it's possible for you to re-write this in a set based manner, that would be ideal. As to why...

TRIGGERS ARE EVIL!

But yeah, I agree with Ian, consolidate triggers wherever possible. Although you can set the trigger order, any time you modify/insert/delete a trigger, that order gets changed...

Jeff Moden (9/30/2009)

---

Very cool... Thanks. I'll take a look at the code.

The two things that bother me about the quirky updates are:

1) The clustered index is required in the...

Matt Whitfield (9/29/2009)

---

Garadin

If you're using say SqlClient under .NET then that gives you meta-data irrespective of the presence of rows.

You can move from one result set to the next with...

richard.smith 47066 (9/29/2009)

---

Hi Matt,

OK I see what you mean. The only thing is that for every procedure it would have to pass its input parameters otherwise you just get...

Also, what do you do with multiple result sets from the same SP?

USE tempdb

CREATE TABLE Test( TestIntint)

INSERT INTO Test(TestInt) SELECT 1

GO

CREATE PROCEDURE TestSP

AS

DELETE FROM Test

SELECT 'A' A, 'B' B, 'C'...