Microsoft SQL Server vs Oracle 8i 1

[murzina]

I would like to find out what is the equivalent syntax in Microsoft SQL Server for dbms_output.put_line('any text'); (this line is OK for Oracle 8i).

 

[robertfah]

What does this do in Oracle?

dbms_output.put_line('any text');

 

[murzina]

It outputs a string "Any text".

 

[RiverGuy]

PRINT 'any text'

is probably what you are looking for.

 

[murzina]

Where can I find a glossary of commands used in Microsoft SQL Server? It's kinda tedious to ask for every command on the forum. I used Oracle 8 and 7 before, but, obviously, it has its own syntax.

 

[RiverGuy]

MSDN.

http://msdn.microsoft.com/en-us/library/ms189826(SQL.90).aspx

 

[SQLSister]

Books on line - SQL Serever Help

also this book might help
SQL in a Nutshell; Kevin and Daniel Kline; O'Reilly;
it has both oracle and SQL Server syntax

"NOTHING is more important in a database than integrity." ESquared