Code Comparison for SQL Server vs. MariaDB

--This is a comment for 1 in SQL Server line

#This is the way to comment 1 line in MariaDB

/*This is a comment in
SQL Server multiple lines
of T-SQL code*/

/*MariaDB is equal to
SQL Server in comments for
multiple lines of code*/

SELECT TOP 5 *
FROM dbo.customer;
GO

SELECT from customer
LIMIT 5;

CREATE FUNCTION dbo.hello_mssqltips()
RETURNS varchar(30)

AS
BEGIN

RETURN ('Hello mssqltips')
END
GO

DELIMITER $$
CREATE FUNCTION hello_mssqltips()
RETURNS varchar(30)
LANGUAGE SQL
BEGIN
RETURN 'Hello mssqltips';
END;
$$
DELIMITER ;

CREATE FUNCTION dbo.hello_withparameter(@name varchar(30))
RETURNS varchar(30)

AS
BEGIN

RETURN ('Hello '+@name)
END
GO

DELIMITER $$
CREATE FUNCTION hello_withparameter(name varchar(30))
RETURNS TEXT
LANGUAGE SQL
BEGIN
RETURN CONCAT('Hello ', name);
END;
$$
DELIMITER ;

select dbo.hello_withparameter('John')
GO

select hello_withparameter('John');

sp_help customer;
GO

describe customer;

sp_helptext object_name

Returns the code of existing procedures, functions and views. It is not applicable to tables.

help create table

help create procedure

help create function

create procedure dbo.repeatsample
@l INT
as
declare @value int=0
while @l>@value-1
BEGIN
SET @value = @value + 1
END
SELECT @value
GO

delimiter //
CREATE PROCEDURE repeatsample(l INT)
BEGIN
SET @value = 0;
REPEAT SET @value = @value + 1;
UNTIL @value > @l END REPEAT;
END
//

exec repeatsample 10

CALL repeatsample(10)//

SELECT @value//

Note that we are calling the @value variable later after iterating in the loop in the procedure.

Save this query in a file named customerquery.sql and save it at c:\.

USE Test;
GO
SELECT * FROM dbo.customer
GO

Now at the cmd prompt run this command:

sqlcmd -i c:\scripts\customerquery.sql -o c:\scripts\results.txt

/*First update the user privileges, in this case the root User to increase the privileges to write files.*/

UPDATE user
SET File_priv = 'Y'
WHERE User = 'root';
FLUSH PRIVILEGES;

/*Now you can save the results of a query in the customer.csv file.*/

select * from customer
into outfile 'c:\\customer.csv'

/*This sample shows the water state according to the temperature*/

CREATE FUNCTION dbo.WaterState(@temperature INT )
RETURNS varchar(10)
as
BEGIN
declare @state varchar(10)
IF @temperature = 100
SET @state = 'Boiled'

IF @temperature between 1 and 99
SET @state = 'Liquid'

ELSE
SET @state = 'Frozen'

RETURN @state

END
GO

DELIMITER //

CREATE FUNCTION WaterState ( temperature INT )
RETURNS varchar(10)

BEGIN
declare state varchar(10) ;
IF temperature = 100 THEN
SET state = 'Boiled';

ELSEIF temperature between 1 and 99 then
SET state = 'Liquid';

ELSE
SET state = 'Frozen';

END IF;

RETURN state;

END; //

DELIMITER ;