Overclock.net - Overclocking.net
     
 
Home Gallery Reviews Blogs Register Today's Posts Mark Forums Read Members List


Go Back   Overclock.net - Overclocking.net > Software, Programming and Coding > Coding and Programming
Reload this Page SQL Help Please

Reply
Page 2 of 2 < 1 2
 
LinkBack Thread Tools
Old 07-05-07   #11 (permalink)
Programmer
 
intel nvidia

Join Date: Nov 2006
Posts: 1,495

Rep: 93 version2 is acknowledged by some
Unique Rep: 76
Trader Rating: 3
Default
Shouldn't SQL syntax be universal. Just... different databases have different features, right?
__________________
System: Duo
CPU
Core 2 Duo E6600 B2		 Motherboard
Asus P5B Deluxe		 Memory
G.SKILL HZ 2x1gb DDR2 800 		Graphics Card
EVGA 9600GSO 384mb
Hard Drive
WD 640gb, Maxtor 160gb		 Sound Card
Audigy 2 ZS		 Power Supply
FSP 450W		 Case
Ultra Aluminus
CPU cooling
Freezer Pro 7		 GPU cooling
Stock		 Monitor
20.1'' SOYO LCD (Wide)
version2 is offline   Reply With Quote
Old 07-05-07   #12 (permalink)
WaterCooler
 
DanNEBTD's Avatar
 
amd nvidia

Join Date: Mar 2006
Location: Boca Raton, FL
Posts: 2,336

Rep: 120 DanNEBTD is acknowledged by manyDanNEBTD is acknowledged by many
Unique Rep: 103
Folding Team Rank: 346
Hardware Reviews: 8
Trader Rating: 8
Default
Quote:
Originally Posted by e_dogg View Post
Ok, I assumed incorrectly that the output was from mySQL (the mySQL editor looks a lot like SQLPlus).

From this link: http://www.princeton.edu/~storacle/sqleditor_tutorial.shtml



Looks like you need the word "modify" in there. And it looks like the table name comes before the constraint name.

Hope that is more helpful.
I see what I did wrong. .. Im an idiot. . last time I delcared it not null @ the table/column creation. now that Im adding it in afterwards I have to use that format. . . I modeled it off of the PK syntax instead. . . I havent double checked yet but I just looked it up in the chapter again . . .I dunno how I missed that. +REP
__________________
Quote:
Originally Posted by GuardianOdin View Post
Overkill doesn't exist on OCN. It's what we do.
XPS M1330: T7500, 4GB, 13.3" LED WXGA, 128 8400 GS, 120GB 5400RPM, 802.11 AGN, 9 cell, Fingerprint, Ultimate x64, 4 Year Accidental Damage/lojack/warranty.
__________________

System: The 1K CFM Machine
CPU
Opty 170 ccb1e 0609fpaw		 Motherboard
A8N32-SLI		 Memory
2 gigs Gskill PC4000 		Graphics Card
EVGA 7950X2
Hard Drive
4x 36gig Raptors raid 0, 1x 200gig storage		 Sound Card
XtremeMusic w/Z5500		 Power Supply
PC&P Silencer 750 Quad		 Case
Mozart Tx
CPU cooling
Stinger V6, quadrad		 OS
Vista Home Premium x86		 Monitor
32" Syntax Olevia
DanNEBTD is offline I fold for Overclock.net DanNEBTD's Gallery   Reply With Quote
Old 07-05-07   #13 (permalink)
Database Developer
 
e_dogg's Avatar
 
intel nvidia

Join Date: Feb 2007
Location: Ventura, CA
Posts: 1,404

Rep: 160 e_dogg is acknowledged by manye_dogg is acknowledged by many
Unique Rep: 137
Trader Rating: 10
Default
w00t!!! Glad we got to the bottom of it! Thanks for the rep!
__________________
System: New Hotness
CPU
E6420 @ 2.8		 Motherboard
Gigabyte GA-P35-DS3L		 Memory
4x1gb G.Skill HZ @ 4-4-4-12 		Graphics Card
Evga 9800GTS+ 800/1943/1200
Hard Drive
250gb + 750gb Seagate 7200.10 SATA		 Power Supply
Rosewill 550w		 Case
Coolermaster CM-690
CPU cooling
Zalman 9500AT		 OS
Vista Ultimate x64		 Monitor
Viewsonic VP171s
e_dogg is offline   Reply With Quote
Old 07-05-07   #14 (permalink)
Database Developer
 
e_dogg's Avatar
 
intel nvidia

Join Date: Feb 2007
Location: Ventura, CA
Posts: 1,404

Rep: 160 e_dogg is acknowledged by manye_dogg is acknowledged by many
Unique Rep: 137
Trader Rating: 10
Default
Quote:
Originally Posted by version2 View Post
Shouldn't SQL syntax be universal. Just... different databases have different features, right?
If the SQL server program you're using is ANSI compliant, then data manipulation commands (select, insert, update, delete) should be pretty much the same. But each flavor of SQL throws its little spin on things because of those different features. Once you know one version, though, it's pretty easy to figure out other versions.
__________________
System: New Hotness
CPU
E6420 @ 2.8		 Motherboard
Gigabyte GA-P35-DS3L		 Memory
4x1gb G.Skill HZ @ 4-4-4-12 		Graphics Card
Evga 9800GTS+ 800/1943/1200
Hard Drive
250gb + 750gb Seagate 7200.10 SATA		 Power Supply
Rosewill 550w		 Case
Coolermaster CM-690
CPU cooling
Zalman 9500AT		 OS
Vista Ultimate x64		 Monitor
Viewsonic VP171s
e_dogg is offline   Reply With Quote
Reply
Page 2 of 2 < 1 2

« Previous Thread | Next Thread »


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools



All times are GMT -4. The time now is 01:35 PM.

Contact Us - Overclock.net - Archive - Top

Overclock.net is a Carbon Neutral Site Creative Commons License Internet Security By ControlScan

Terms of Service / Forum Rules | Privacy Policy | Advertising | Become an Official Vendor
Copyright © 2008 Shogun Interactive Development. Most rights reserved.
Page generated in 0.21876 seconds with 9 queries