FREE AI-Enhanced Online SQL Server Compiler

Untitled*

You must execute the code again to save those values in the database.

-- INIT database
CREATE TABLE Product (
  ProductID INT IDENTITY(1, 1),
  Name VARCHAR(100),
  Description VARCHAR(255)
);

INSERT INTO Product(Name, Description) VALUES ('Entity Framework Extensions', 'Use <a href="https://entityframework-extensions.net/" target="_blank">Entity Framework Extensions</a> to extend your DbContext with high-performance bulk operations.');
INSERT INTO Product(Name, Description) VALUES ('Dapper Plus', 'Use <a href="https://dapper-plus.net/" target="_blank">Dapper Plus</a> to extend your IDbConnection with high-performance bulk operations.');
INSERT INTO Product(Name, Description) VALUES ('C# Eval Expression', 'Use <a href="https://eval-expression.net/" target="_blank">C# Eval Expression</a> to compile and execute C# code at runtime.');

-- QUERY database
SELECT * FROM Product;
SELECT * FROM Product WHERE ProductID = 1;

SELECT 
    definitions = JSON_QUERY('{"NAME": "VARCHAR(23)", "DESCRIPTION": "VARCHAR(23)"}'),
    data = 
    (
        SELECT NAME, DESCRIPTION
        FROM (SELECT TOP 1 NAME, DESCRIPTION  FROM Product) v(NAME, DESCRIPTION)
        FOR JSON PATH, WITHOUT_ARRAY_WRAPPER
    )
FOR JSON PATH, WITHOUT_ARRAY_WRAPPER;

ProductID	Name	Description
1	Entity Framework Extensions	Use Entity Framework Extensions to extend your DbContext with high-performance bulk operations.
2	Dapper Plus	Use Dapper Plus to extend your IDbConnection with high-performance bulk operations.
3	C# Eval Expression	Use C# Eval Expression to compile and execute C# code at runtime.

ProductID	Name	Description
1	Entity Framework Extensions	Use Entity Framework Extensions to extend your DbContext with high-performance bulk operations.

JSON_F52E2B61-18A1-11d1-B105-00805F49916B
{"definitions":{"NAME": "VARCHAR(23)", "DESCRIPTION": "VARCHAR(23)"},"data":"{\"NAME\":\"Entity Framework Extensions\",\"DESCRIPTION\":\"Use Entity Framework Extensions<

(1 rows affected)

(1 rows affected)

(1 rows affected)

(3 rows affected)

(1 rows affected)

(1 rows affected)