SQL Server——显示名称值对作为列吗?

I have tables as follows:

我有以下表格:

CREATE TABLE case_form 
(
    id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    title VARCHAR(50) NOT NULL,
    description TEXT NOT NULL,
    PRIMARY KEY (id)
)

INSERT INTO case_form (id, title, description)
VALUES (1, 'test', 'test')

CREATE TABLE case_fields 
(
    id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    name VARCHAR(50) NOT NULL,
    value TEXT NOT NULL,
    case_form_id INT(10) UNSIGNED NOT NULL,
    PRIMARY KEY (id),
    INDEX FK__case_form (case_form_id),
    CONSTRAINT FK_case_form FOREIGN KEY (case_form_id) REFERENCES case_form 
)

INSERT INTO case_fields (name, value, case_form_id)
VALUES ('type', 'Request', 1), ('category', 'Sales', 1)
CREATE TA