By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
Id | Name | Mark |
---|---|---|
Id | Name | Mark |
1 | Medi | 10 |
2 | Ibra | 15 |
3 | Simo | 20 |
SELECT
[Id] = CONVERT(sql_variant, N'Id'),
[Name] = CONVERT(sql_variant, N'Name'),
[Mark] = CONVERT(sql_variant, N'Mark')
UNION ALL
SELECT * FROM dbo.Student;