5 replies to this topic

[Mr. Matt]

Does anybody know the difference between the two SQL languages. Anybody know a website where i can do a quick overview of Microsoft SQL 2005 as i need to do a project envolving it.

Many Thanks

Matt

[kcd]

Im pritty shur that you cant connect to sql with the web.
Cause its ment for programming and has not created a webcode for it yet.
with mysql you can use the webfunctions <? mysql_arrey() ?>
They both do the same thing except sql isnt as popular yet.
Once people start to learn it they will design it for more things.

[Mr. Matt]

no u can use it on the websites cos people do use it on the websites, i just dont kno the difference in the SQL syntax

[rc69]

That's the beauty of SQL. It's semi-standardized across several platforms. Each database has little features/functions that only they can use, but other then that it's a one set runs them all sorta thing.

I don't know where you can get the specifics on msSQL, but mySQL does have a developers page (in my sig). Try googling "SQL" or some variations of it with microsoft.

gl.

p.s. kcd, sql is not meant for programming, it's a "Structured Query Language" used for databases more then anything else. And there's barely a dynamic site that doesn't use it in one form or another.

[Mr. Matt]

thanks rc69

from what i have seen and read its not too different MSSQL from MySQL. instead of mysql_connect() its mssql_connect() and the SELECT syntax dosnt look any different really

[Sicloan]

the actual syntax of the queries shouldnt really change. There might be some functions in the sql that are different, like max() or something similar, but other than that i believe they are pretty much the same.

And of course the functions you use to connect are going to be different