Differences

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

sql-server-to-mariadb [June 12, 2018 11:55 am]
sqlines
sql-server-to-mariadb [June 18, 2018 2:20 pm] (current)
sqlines
Line 19: Line 19:
===== Migration Reference ===== ===== Migration Reference =====
 +  * [[/sql-server-to-mariadb#sql-language-elements|SQL Language Elements]]
  * [[/sql-server-to-mariadb#data-types|Data Types]]   * [[/sql-server-to-mariadb#data-types|Data Types]]
  * [[/sql-server-to-mariadb#built-in-sql-functions|Built-in SQL Functions]]   * [[/sql-server-to-mariadb#built-in-sql-functions|Built-in SQL Functions]]
  * [[/sql-server-to-mariadb#create-procedure-statement|CREATE PROCEDURE]]   * [[/sql-server-to-mariadb#create-procedure-statement|CREATE PROCEDURE]]
  * [[/sql-server-to-mariadb#transact-sql-statements|Transact-SQL Statements]]   * [[/sql-server-to-mariadb#transact-sql-statements|Transact-SQL Statements]]
 +
 +===== SQL Language Elements =====
 +
 +Converting SQL language elements:
 +
 +| | **SQL Server** || **MariaDB** ||
 +| 1 | //string + string2 + ...// | String concatenation | CONCAT(//string, string2, ...//) ||
 +| 2 | @@IDENTITY | Returns the last-inserted identity value | LAST_INSERT_ID() ||
===== Data Types ===== ===== Data Types =====
Line 98: Line 107:
   
 +Transaction statements:
 +| | **SQL Server** || **MariaDB** |
 +| 1 | BEGIN TRANSACTION %%|%% TRAN | Begin a transaction | START TRANSACTION |
 +| 2 | COMMIT TRANSACTION %%|%% TRAN | Commit transaction | COMMIT |
 +| 3 | ROLLBACK TRANSACTION %%|%% TRAN | Rollback transaction | ROLLBACK |