If you have come to SQL Server from an Oracle, these tips on common tasks may be handy:
| To do this | Oracle syntax | SQL Server syntax |
| Create table from SQL select | create table NEWTABLE as select * from TABLE | select * into NEWTABLE from SOURCETABLE |
Oracle / SQL Server cheat sheet
Leave a Reply
You must be logged in to post a comment.