mysql 语句转换sqlserver

-- MySQL
CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(255)
);

-- SQL Server
CREATE TABLE users (
    id INT PRIMARY KEY,
    name NVARCHAR(255)
);

-- MySQL
SELECT * FROM users LIMIT 10, 20;

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

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

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

-- MySQL
CREATE TABLE products (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    price DECIMAL(10, 2)
);

SELECT * FROM products WHERE price > 100 LIMIT 10;

-- SQL Server
CREATE TABLE products (
    id INT PRIMARY KEY,
    name NVARCHAR(255),
    price DECIMAL(10, 2)
);

SELECT TOP 10 * FROM products WHERE price > 100;