Viewing 15 posts - 51,556 through 51,570 (of 59,072 total)
Utsab Chattopadhyay (3/20/2008)
Many thanks in...
March 21, 2008 at 9:36 am
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...
March 21, 2008 at 9:18 am
Thanks for the feedback, Selena... I've made the same mistake many a time. 😛
March 21, 2008 at 9:00 am
"The difficult can be done immediately, the impossible takes a little longer." — Army Corp. of Engineers
March 20, 2008 at 9:21 pm
Sure... go to the same source you found the info for the undocumented sp_MSForEachTable and find sp_MSForEachDB.
March 20, 2008 at 8:34 pm
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...
March 20, 2008 at 8:32 pm
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 <...
March 20, 2008 at 8:30 pm
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...
March 20, 2008 at 8:20 pm
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.
March 20, 2008 at 8:18 pm
That would have been a good one to ask for some data on... 😉
March 20, 2008 at 8:15 pm
For what? Got an example of the PL/SQL that you're talking about?
March 20, 2008 at 8:04 pm
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...
March 20, 2008 at 8:01 pm
tuseau (3/19/2008)
Basically...
March 20, 2008 at 4:01 pm
Matt Miller (3/19/2008)
Gareth Williams (3/19/2008)
Thanks Jeff for your help. I thought that might be the answer but hoping not.
I have to ask - what happens to all of the previous...
March 20, 2008 at 3:55 pm
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...
March 20, 2008 at 3:45 pm
Viewing 15 posts - 51,556 through 51,570 (of 59,072 total)