SSMS has a lot of customization features. By default when we copy query result it’s not include columns header. To enable this feature, just set the SSMS setting as
- From Tools menu, select “Options…”
- From left, Select “Query Results” and expand it
- Select “SQL Server” and Click on “Result to Grid”
-
Now from right, Click on “Include columns header when copying or saving results”
Great reading your blogg post
LikeLike