Utsab Chattopadhyay (3/20/2008)

---

Thanks a lot. But per my understanding, this approach will give number as GUID (B85E62C3-DC56-40C0-852A-49F759AC68FB). Is it possible to get a number (Like identity returns) instead?

Many thanks in...

Sure... understood... but you want to create an auto-increment column, as well as creating a table. That's not the same between RDBMS's... for example, Oracle doesn't even allow for...

Thanks for the feedback, Selena... I've made the same mistake many a time. 😛

"The difficult can be done immediately, the impossible takes a little longer." — Army Corp. of Engineers

Sure... go to the same source you found the info for the undocumented sp_MSForEachTable and find sp_MSForEachDB.

Just a programming note... the method that Matt used is a lot faster than recursive CTE's like the one you have over the long haul...

Thanks for sharing... but your CTE has an error in it... it won't return all of the days of March... it misses the last day because you of the <...

This is an SQL Server forum... and SQL is not SQL between RDBMS's... if you want MySQL help, I suggest you find a MySQL forum or refer to the documentation...

A "UniqueIdentifier" datatype and a default of NEWID() would probably fit the bill (although, I don't care for them. Lookup both items in Books Online for more details.

That would have been a good one to ask for some data on... 😉

For what? Got an example of the PL/SQL that you're talking about?

To solve the problem of both auditing the initial change AND make life a bit easier on the type of "fired" recovery that you're talking about, without the additional overhead...

tuseau (3/19/2008)

---

The problem itself wasn't quite what I was making of it. I didn't need to return the table name from the context of the insert statement after all.

Basically...

Matt Miller (3/19/2008)

---

I have to ask - what happens to all of the previous...

1) I can use a cursor in the trigger to get all the records from the Inserted table and populate the temporary table.

(Assuming that Inserted table has only records...