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