SQL Help Please - Page 2 - Overclock.net

version2 · 07-05-07

Shouldn't SQL syntax be universal. Just... different databases have different features, right?

DanNEBTD · 07-05-07

Quote:

Originally Posted by e_dogg

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

e_dogg · 07-05-07

w00t!!! Glad we got to the bottom of it!

Thanks for the rep!

e_dogg · 07-05-07

Quote:

Originally Posted by version2

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.

		Overclock.net - Overclocking.net > Software, Programming and Coding > Coding and Programming
SQL Help Please

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