Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wolverine82
Starting Member
5 Posts |
 Posted - 2010-06-12 : 00:01:25
|
| Hi All,I am new to SQL programming.Just have a quick question as to if i write a query in SQL how will it differ in T-SQL or how can i show it in T-SQL. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
wolverine82
Starting Member
5 Posts |
Posted - 2010-06-12 : 08:15:32
|
| Thanks Tara..No Wonder i was so confused and asked such a stupid question Sorry.So basically T-SQL is just sql used in Microsoft SQL server.so basically if we write a query and execute it in oracle will the same query execute in MS SQL server or will the syntax change.Is there any link where i can get more knowledge about it. |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-06-12 : 09:03:07
|
| SQL is an ANSI standard used to program any RDBMS but there are many different vendor versions of the SQL language like TSQL which is used for Microsoft SQL Server and PL/SQL is used for Oracle.Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless. PBUH |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-06-12 : 09:04:48
|
quote:
Originally posted by wolverine82
Is there any link where i can get more knowledge about it.
Have a look here http://en.wikipedia.org/wiki/SQLLimitations live only in our minds. But if we use our imaginations, our possibilities become limitless. PBUH |
|
|
|
wolverine82
Starting Member
5 Posts |
Posted - 2010-06-12 : 09:27:43
|
| Thanks Idera for clarifying my doubts.I will be on my way to learning T-SQL now :) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-06-12 : 09:32:36
|
"So basically T-SQL is just sql used in Microsoft SQL server"Exactly that!" if we write a query and execute it in oracle will the same query execute in MS SQL server"Many simple things will ... but the differences become apparent fairly quickly.If you want to write an application that works with both Oracle and MS SQL then you have two choices I reckon:1) Use some middle-ware that allows you to only use a single interface from your App. I did this many years ago, in the end we threw it away because the queries were lowest-common-denominator and performed badly.2) Write two versions - the Oracle one and the MS SQL one.We then did Option (2) for a few years (and supported two other databases too) and then we took option 3  which was to only support MS SQL - on the grounds that we thought we could persuade all "Oracle-only" places to allow MS SQL to be installed, but forcing people to use Oracle was unlikely to be acceptable ...... so here I am now, 15 years later, able to answer questions in an MS SQL forum ...  |
|
|
|
|
|
|
Writing a query in sql and it's relation to T-Sql