Re: differences between ORACLE and MS SQL

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

From: test (a_at_a.a)
Date: 01/18/05 

Date: Tue, 18 Jan 2005 08:09:13 +0800

do not cross post!

> 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

in ms-sql as the same 1) 2)

> 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?
why?

>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

use datediff
or
between '1/6/2002' and '30/6/2002'