Viewing 15 posts - 53,056 through 53,070 (of 59,064 total)
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
If UDFs can be non-deterministic then the optimiser has to assume that if you wrote a query which implicitly calls a UDF 10,000 times, then you actually want it to...
January 5, 2008 at 10:13 pm
Hey Loner... how did your recent interview go?
January 5, 2008 at 8:31 pm
In other words, you can delete the parent records and the child records will automatically be deleted.
January 5, 2008 at 8:22 pm
Viewing 15 posts - 53,056 through 53,070 (of 59,064 total)