| # | Oracle 語法 | SQL Server 語法 | 備註 |
| 1 | CREATE OR REPLACE PROCEDURE | CREATE PROCEDURE | 移除 OR REPLACE,需先 DROP 或用 ALTER |
| 2 | 變數 v_id | @v_id | 所有區域變數加 @ |
| 3 | IS / AS | AS | 統一為 AS,並將 BEGIN 移至 AS 直後 |
| 4 | CURSOR c IS ... | DECLARE c CURSOR LOCAL FOR ... | 游標宣告語法差異大 |
| 5 | FETCH c INTO ... | FETCH NEXT FROM c INTO ... | |
| 6 | IF c%NOTFOUND THEN | IF @@FETCH_STATUS <> 0 BEGIN | |
| 7 | IF c%FOUND THEN | IF @@FETCH_STATUS = 0 BEGIN | |
| 8 | ; (陳述式結尾) | 移除或換行 | TSQL 以換行/GO 分隔 |
| 9 | := (指派) | = | 需手工加 SET:SET @v = 1 |
| 10 | THEN | BEGIN | 配合 END 取代 END IF |
| 11 | END IF | END | |
| 12 | IN (參數模式) | 移除 | TSQL 參數無 IN/OUT 關鍵字 |
| 13 | NVL(a,b) | ISNULL(a,b) | |
| 14 | SYSDATE | GETDATE() | |
| 15 | VARCHAR2(n) | VARCHAR(n) | 需補全長度 |
| 16 | ELSIF | ELSE IF | |
| 17 | || (字串連接) | + | |