mysql语句转换成sqlserver

-- MySQL
SELECT CONCAT('Hello', ' ', 'World');

-- SQL Server
SELECT 'Hello' + ' ' + 'World';

-- MySQL
SELECT * FROM table_name LIMIT 10 OFFSET 20;

-- SQL Server
SELECT * FROM table_name ORDER BY id OFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY;

-- MySQL
SELECT * FROM table_name WHERE column = 'value';

-- SQL Server
SELECT * FROM table_name WHERE column = 'value';

-- MySQL
SELECT * FROM table_name WHERE column IN (SELECT column FROM another_table);

-- SQL Server
SELECT * FROM table_name WHERE column IN (SELECT column FROM another_table);

-- MySQL
SELECT IF(column = 'value', 'True', 'False');

-- SQL Server
SELECT IIF(column = 'value', 'True', 'False');

-- MySQL
CREATE INDEX index_name ON table_name (column_name);

-- SQL Server
CREATE INDEX index_name ON table_name (column_name);

-- MySQL
DELIMITER //
CREATE TRIGGER trigger_name
AFTER INSERT ON table_name
FOR EACH ROW
BEGIN
    -- 触发器逻辑
END //
DELIMITER ;

-- SQL Server
CREATE TRIGGER trigger_name
ON table_name
AFTER INSERT
AS
BEGIN
    -- 触发器逻辑
END;