2007-03-16 20:59:28 · 2 answers · asked by paul.sanjay 1 in Computers & Internet ➔ Programming & Design
SQL is a query language implemented by microsoft sql server
2007-03-16 23:33:47 · answer #1 · answered by Anonymous · 0⤊ 0⤋
There is the standard sql-92 which is in every database management system such as oracle, microsoft sql server, ibm db2, mysql ...etc.
meaning a simple code such as:
"select * from table1 as t1 join table2 as t2 on t1.code = t2.code"
will work on any dbms.
But when it comes to the extra features of each individual dbms, then those dbms differ; for instance, ms sql server 2005 has a new xml datatype while mysql doesn't; ms access uses a function called date() while ms sql server uses getdate(); so beside supporting the standard sql-92, all of those various dbms including ms sql server have their own non-standard sql code.
So any thing under sql-92 will work in ms sql server but not versa vice
2007-03-17 04:30:10 · answer #2 · answered by Coosa 2 · 1⤊ 0⤋