Viewing 15 posts - 53,056 through 53,070 (of 59,068 total)
Andrew Whettam (1/6/2008)
January 7, 2008 at 6:24 am
No, no... it's not that... in SQL Server, you have a Deleted and Inserted table... in Oracle, they are not tables... they are essentially variables that contain 1 row... you...
January 7, 2008 at 6:12 am
Heh... I'm confused... I recommended generic names, not DATABASE_MODULE_TABLE...
January 7, 2008 at 5:41 am
I see that... and it still comes out at just "which scripting language does...".
The other thing is, you should never rely just on the title of a post to convey...
January 7, 2008 at 5:35 am
karthikeyan (1/7/2008)
2. Same for permanent tables...
IF OBJECT_ID('dbo.permanenttablename','U') IS NOT NULL PRINT 'Table Exists' ELSE PRINT 'Table Not Exists'
...
January 7, 2008 at 5:24 am
TheSQLGuru (1/6/2008)
Does Oracle really not have temporary tables, or is it just non-performant to use them??
Oracle does have "temp tables" but even though different sessions cannot see the data from...
January 6, 2008 at 9:22 am
Andrew Whettam (1/6/2008)
Jeff, you have made some good points, but pardon me for thinking it comes across as just a teensy bit anti Oracle!
Absolutely incorrect, Andrew... I'm a LOT anti-Oracle!...
January 6, 2008 at 8:44 am
Heh... that's exactly what sp_MSForEachDatabase does... it's nothing but a huge cursor...
January 6, 2008 at 8:32 am
It's a "hint" on how to post data... 😛
January 6, 2008 at 12:01 am
Oh yeah... almost forgot... if you hate the fact that SQL Server 2000's VARCHAR only goes up to 8,000 characters and did hand-springs over SQL Server 2005's VARCHAR(MAX) so you...
January 5, 2008 at 11:57 pm
Jeez... where do I start...
1. The output of SQL Server stored procedures is easily used as a result set... for Oracle, you must build a reference cursor in a...
January 5, 2008 at 11:43 pm
Then, I guess I don't understand the need for the join... the query is just returning every transaction number that also has a match in the SKU table... multiple...
January 5, 2008 at 10:32 pm
Great post, Derek... good example tests you attached.
January 5, 2008 at 10:16 pm
Viewing 15 posts - 53,056 through 53,070 (of 59,068 total)