SQL commands ?

[AOLEURO]

Hi

Where can I find a MS:SQL 2K function and sql command overview.

I need to know if where is a function like NVL(xxx,yyy) as in Oracle databases.

Thanks
AOL

 

[mwolf00]

IsNUll(val1, val2)

means if val1 IS NULL then use val2 -----------------------------------------------------------------
"Whether you think that you can, or that you can't, you are usually right."
- Henry Ford (1863-1947)

mikewolf@tst-us.com

 

[tlbroadbent]

SQL BOL contains details of functions and T-SQL commands. Check out the following link for a white paper about "Migrating Oracle Databases to SQL Server 2000." It lists which T-SQL functions and commands are equivalent to various Oracle functions and commands.

http://www.microsoft.com/sql/techinfo/deployment/2000/MigrateOracle.asp

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.