SQL Server vertical table and horizontal table conversion method, SQL mutual conversion

SQL Server vertical table and horizontal table conversion method, SQL mutual conversion

1. convert a vertical table to a horizontal table

Table_A:

Converted structure:

SQL example for converting a vertical table to a horizontal table:

SELECT Name, SUM (case when Course = n' en 'THEN GradeELSE 0END) AS Chinese, SUM (case when Course = n' THEN GradeELSE 0END) AS Mathematics, SUM (case when Course = n' THEN GradeELSE 0END) AS EnglishFROM dbo. table_AGROUP BY Name

2. Horizontal table to vertical table

Horizontal table structure Table_ B:

Converted table structure:

SQL example of horizontal table to vertical table:

SELECT Name ,'Chinese' AS Course ,Chinese AS ScoreFROM dbo.Table_BUNION ALLSELECT Name ,'Mathematics' AS Course ,Mathematics AS ScoreFROM dbo.Table_BUNION ALLSELECT Name ,'English' AS Course ,English AS ScoreFROM dbo.Table_BORDER BY Name ,Course DESC 

The preceding section describes how to convert SQL Server vertical tables and horizontal tables. I hope it will be helpful to you. If you have any questions, please leave a message, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!