Re: differences between ORACLE and MS SQL

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 01/18/05 

Date: Tue, 18 Jan 2005 08:57:40 +0100

You might want to check
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx
as well. 

-- 
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"evagelos" <evagelos_21@hotmail.com> wrote in message
news:uzOKRtO$EHA.2012@TK2MSFTNGP15.phx.gbl...
> i want to create some queerys in MS-SQL
>
> 1)
> this queery in ORACLE-SQL works fine , in MS-SQL?
> SELECT     code_card, card_date + 31
> FROM        card
>
> i searce and find out that i must use "DATEADD ( datepart , number,
date )"
> but how?
>
> 2)
> this queery in ORACLE-SQL works fine , in MS-SQL?
> SELECT     card_dates, SUM(card_quantity)
> FROM         card_transactios
> GROUP BY card_dates
>
> i want to return my the sumarize  but if i have 2 card_transactions in
> febrary it return to me both of them
> what i am doign wrong?
>
> 3)
> i want to find all card_transaction for month "may"
> i must write " LIKE '*/6/2002'  "
> but it returns me an error "your entry cannot be converted to a valid
> daytime value
>
> 4) store procedure is like triggers in ORACLE-SQL?
>
>

Relevant Pages

  • Re: differences between ORACLE and MS SQL
    ... Also look at these to see how to handle dates properly in SQL Server. ... > this queery in ORACLE-SQL works fine, in MS-SQL? ...
    (microsoft.public.vb.database.dao)
  • Re: differences between ORACLE and MS SQL
    ... Also look at these to see how to handle dates properly in SQL Server. ... > this queery in ORACLE-SQL works fine, in MS-SQL? ...
    (microsoft.public.sqlserver.odbc)
  • Re: differences between ORACLE and MS SQL
    ... Also look at these to see how to handle dates properly in SQL Server. ... > this queery in ORACLE-SQL works fine, in MS-SQL? ...
    (microsoft.public.vb.general.discussion)
  • Re: differences between ORACLE and MS SQL
    ... Also look at these to see how to handle dates properly in SQL Server. ... > this queery in ORACLE-SQL works fine, in MS-SQL? ...
    (microsoft.public.sqlserver.connect)
  • Re: differences between ORACLE and MS SQL
    ... Also look at these to see how to handle dates properly in SQL Server. ... > this queery in ORACLE-SQL works fine, in MS-SQL? ...
    (microsoft.public.sqlserver.tools)