您需要查询重写 [ ^ ]。检查这些

Microsoft SQL Server和Oracle比较 [ ^ ]

Oracle和MS-SQL之间的SQL语法差异 [ ^ ]



在Oracle和Sql Server之间迁移 - 第一部分 [ ^ ]

从Oracle迁移到Sql Server - 第二部分 [ ^ ]

从Oracle迁移到Sql Server - 第III部分 [ ^ ]

从Oracle迁移到Sql服务器 - 第四部分 [ ^ ]

从Oracle迁移到Sql Server - 第V部分 [ ^ ]



对于日期/日期格式，

SQL Server日期格式 [ ^ ]

SQL日期函数 [ ^ ]

You need to Query rewrite[^]. Check these
Microsoft SQL Server and Oracle Compared[^]
SQL Syntax differences between Oracle and MS-SQL[^]

Migrating between Oracle and Sql Server - Part I[^]
Migrating from Oracle to Sql Server - Part II[^]
Migrating from Oracle to Sql Server - Part III[^]
Migrating from Oracle to Sql Server - Part IV[^]
Migrating from Oracle to Sql Server - Part V[^]

For Dates/Date formats,
SQL Server Date Formats[^]
SQL Date Functions[^]

这可能会对你有所帮助。

http://www.swissql.com/products/sql-translator/sql-converter.html [ ^ ]

This might help you refer here.
http://www.swissql.com/products/sql-translator/sql-converter.html[^]