Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««2223242526»»

SQL or Oracle Expand / Collapse
Author
Message
Posted Tuesday, February 17, 2009 7:23 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 12:01 AM
Points: 1,746, Visits: 763
GSquared (2/17/2009)
Max (2/17/2009)
Man, you guys are so lucky, we were so poor I had to push the horse up the hill. ;)


Sisyphus move over! New guy with version 2.0 is here! :)


You had a hill to push up, we couldnt even afford the hill....


Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #659009
Posted Wednesday, February 18, 2009 2:06 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:59 PM
Points: 31,082, Visits: 15,529
You had a hill to push up, we couldnt even afford the hill....



Excellent, ROFL.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #659861
Posted Wednesday, February 18, 2009 6:39 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 7:07 AM
Points: 247, Visits: 356
Ford Fairlane (2/17/2009)
GSquared (2/17/2009)
Max (2/17/2009)
Man, you guys are so lucky, we were so poor I had to push the horse up the hill. ;)


Sisyphus move over! New guy with version 2.0 is here! :)


You had a hill to push up, we couldnt even afford the hill....


Only after we built the hill, with our bare hands, after feeding the chickens and milking the cows and ploughing the fields.


Max
Post #660000
Posted Thursday, February 19, 2009 8:07 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 13,872, Visits: 9,596
Max (2/18/2009)
Ford Fairlane (2/17/2009)
GSquared (2/17/2009)
Max (2/17/2009)
Man, you guys are so lucky, we were so poor I had to push the horse up the hill. ;)


Sisyphus move over! New guy with version 2.0 is here! :)


You had a hill to push up, we couldnt even afford the hill....


Only after we built the hill, with our bare hands, after feeding the chickens and milking the cows and ploughing the fields.


Oracle sure does seem to inspire some odd metaphores...


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #660376
Posted Wednesday, March 18, 2009 4:13 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 9:39 AM
Points: 3,428, Visits: 14,438
IBM to buy SUN if MySQL is killed in the deal there will be a fight because many web developers like MySQL because it is simple and ISP gives them unlimited space with MySQL. These people thinks even SQL Server is too complicated to understand. So IBM will own three full RDBMS that was what the original ANSI people did not want. I think uncle sam should force IBM to sell both Informix and MySQL.

http://blogs.barrons.com/techtraderdaily/2009/03/18/sun-micro-could-there-be-multiple-bidders/?mod=yahoobarrons




Kind regards,
Gift Peddie
Post #678981
Posted Wednesday, March 25, 2009 7:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 28, 2013 4:08 AM
Points: 6, Visits: 79
I have read the first few pages, not the entire thread. A little long :)
Compared to Oracle, SQL seems to be a better option for those that do not want to pay too much for their database. I have dealt mainly with SQL, not much with Oracle. So what I can say is that SQL is an interesting product, that really gives you a good tool to work your data.


Visit Talend and Talendforge for open source ETL and data integration.
Post #683314
Posted Thursday, May 14, 2009 3:51 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, May 19, 2014 9:19 AM
Points: 81, Visits: 285
please note: all comments listed below are my personal opinion, all rights reserved for changing at anytime. and not to be taken literally. as It refers to any manufacturers of dairy products

Well - I officially don't like Oracle, not to be lazy in my work but why is it so bloody long winded to add an incrementing ID to a field.

step1 Create a table, place a number field,
step2 Create a sequence to generate your IDs,
Step3 Create a trigger get the next value from your sequence and do a "before insert do."

Geeze! how long! in SQL server its just create table, add Integer field, double click on Indentity in properties window.. Done.

yup. SQL server for me.. easy life...
Post #716742
Posted Thursday, May 14, 2009 7:03 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:58 PM
Points: 20,705, Visits: 32,356
hb21l6 (5/14/2009)
please note: all comments listed below are my personal opinion, all rights reserved for changing at anytime. and not to be taken literally. as It refers to any manufacturers of dairy products

Well - I officially don't like Oracle, not to be lazy in my work but why is it so bloody long winded to add an incrementing ID to a field.

step1 Create a table, place a number field,
step2 Create a sequence to generate your IDs,
Step3 Create a trigger get the next value from your sequence and do a "before insert do."

Geeze! how long! in SQL server its just create table, add Integer field, double click on Indentity in properties window.. Done.

yup. SQL server for me.. easy life...


Doesn't have to be an integer column to use identity. I've made a column defined DECIMAL(18,0) an identity column.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #716885
Posted Thursday, May 14, 2009 11:13 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:59 PM
Points: 31,082, Visits: 15,529
Or you can use a GUID in SQL Server with a default of NEWID()







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #717202
Posted Thursday, May 14, 2009 11:24 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:58 PM
Points: 20,705, Visits: 32,356
Steve Jones - Editor (5/14/2009)
Or you can use a GUID in SQL Server with a default of NEWID()

And in SQL Server 2005 (and later) you can also use NEWSEQUENTIALID ( ) as a default.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #717218
« Prev Topic | Next Topic »

Add to briefcase «««2223242526»»

Permissions Expand / Collapse