Differences

This shows you the differences between two versions of the page.

--- db2-to-sql-server [May 08, 2026 7:05 am]
sqlines
+++ db2-to-sql-server [May 08, 2026 7:05 am] (current)
sqlines
@@ Line 128: / Line 128: @@
 | | **DB2** || **SQL Server** |
 | 1 | [[/db2-to-sql-server/select_new_table_insert|SELECT ... FROM NEW TABLE (INSERT ...)]] | Get identity after insert | [[/db2-to-sql-server/select_new_table_insert|INSERT and SCOPE_IDENTITY()]] |
-| 1 | SYSIBM.SYSDUMMY1 | Single row, single column dummy table | FROM clause removed |
+| 2 | SYSIBM.SYSDUMMY1 | Single row, single column dummy table | FROM clause removed |
 |:::| SYSIBM.DUAL |:::|:::|
-| 2 | FOR READ ONLY | Retrieve rows for read only | Removed |
+| 3 | FOR READ ONLY | Retrieve rows for read only | Removed |
-| 3 | WITH UR | Uncommitted read | WITH (NOLOCK) |
+| 4 | WITH UR | Uncommitted read | WITH (NOLOCK) |
 Row limitation: