SQL Server vsoracle simple syntax comparison

1. SQL SERVER variables must start.

2. You do not need to write a semicolon Terminator after the SQL SERVER statement.

3. oracle variable type number can be changed to decimal of SQL server

4. The oracle variable type varchar2 can be changed to the varchar of SQL server.

5. SQL SERVER defines variables and transmits parameters. It is best to add the parameter size value, for example, varchar (50)

6. SQL SERVER cannot use ROWID or ROWNUM (but can be replaced by TOP)

7. The nvl function in oracle is replaced by the ISNULL function in SQL SERVER.

8. SQL SERVER user-defined functions cannot modify global table data (only table data within the scope of user-defined functions can be modified). Therefore, it is best to use stored procedures instead of functions for table modification.