May 18, 2004 at 11:07 pm
Hello everybody
Please help me find differene between PL-Sql and Transact-Sql.
I have no knowledge about Pl-sql,
Do we use Pl-sql in sql server 7/2000?
If we do then plz tell where do we use it and why?
which is better of two,Pl-sql or Transact sql?
Is there ne situation where we can not do without PL-sql?
Ur help is greatly appreciated.
Jaishree
May 19, 2004 at 1:08 am
The difference is that they are two different languages.
Both SQL, but still different dialects.
SQL Server uses Transact SQL only.
You cannot use PL-SQL specifics in SQL Server at all, because SQL Server does not understand PL-SQL.
/Kenneth
May 19, 2004 at 9:08 am
PL/SQL and SQLPlus are Oracle database languages.
-SQLBill
May 20, 2004 at 2:50 am
I see.
Thanks alot Kenneth and SQLBill
Jaishree
May 20, 2004 at 10:30 am
To add to our comments, all SQL languages use the same BASIC commands: SELECT, FROM, WHERE, GROUP BY, ORDER BY, UPDATE, DELETE, INSERT and some others.
But the languages differ in how they use other SQL commands. Here's a couple of examples:
Both Oracle and SQL Server have a variable character datatype. SQL Server calls it VARCHAR and Oracle calls it VARCHAR2.
If you need to convert from a variable character date to a DATE datatype:
SQL Server has DATETIME datatype, which requires both date and time (or it uses a default) and this is the way to convert:
CONVERT(DATETIME, '2004-05-20 12:00:00', 121) or CAST('2004-05-20 12:00:00' AS DATETIME).
ORACLE uses a separate DATE and TIME datatype. To convert to DATE:
TO_DATE('2004-05-20', 'YYYY-MM-DD')
And that's just a couple of examples of the differences. There are many more.
-SQLBill
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy