SQL Server的隐藏功能

SELECT OPENJSON(orders) AS data
, items->>'order_id' AS order_id
, items->>'order_status' AS order_status
, items->>'order_total' AS order_total
FROM orders
WHERE 1 = 1;

SELECT CAST(IMAGESTREAM ->>0 AS IMAGE) AS image
, IMAGESTREAM ->>0 AS image_length
FROM images
WHERE 1 = 1;

SELECT UNPIVOT(MAX(DISTINCT row_value) FOR row_num IN (MAX(idx), SUM(val)) FOR idx IN (row_id, row\_value)) AS data
INTO #maxresults
FROM table_name AS base_table
WITH (MAXRECURSION 1000);

SELECT * FROM #maxresults;

SELECT  
    name AS [@name],
    schema\_name(schema\_id) AS SchemaName,
    type_desc AS Type,
    modify\_time AS ModifyTime,
    modify\_by AS ModifyBy,
    modify\_by\_property AS ModifyByProperty
FROM
    user\_objects
WHERE
    type = 'U' AND is\_ms\_shipped = 0
FOR XML PATH('').NODE();

CREATE VIEW check_vat AS
SELECT
    country
FROM
    orders;
GO

CREATE TRIGGER check_vat_trigger
ON check_vat
AFTER INSERT, UPDATE, DELETE AS
BEGIN
    IF EXISTS (SELECT * FROM Deleted)
    BEGIN
        RAISERROR('VAT not allowed for this country.', 16, 1);
    END;
    ELSE
    BEGIN
        NULL;
    END;
END;

GO

ALTER DATABASE my_database
SET EDITION = 'Enterprise,Express,Advanced,Business Intelligence';