开发者

Copy SQL 2005 view result column headers?

开发者 https://www.devze.com 2022-12-22 13:20 出处：网络

Is there a way to copy View output column headers along with the data?There is a setting in Options to include 开发者_如何学Pythoncolumn headers with query results, but that only works with \"New Quer

相关专题：sql sql-server sql-server-2005

Is there a way to copy View output column headers along with the data? There is a setting in Options to include 开发者_如何学Pythoncolumn headers with query results, but that only works with "New Query" and Stored Procedure output.

Looks like SSMS 2008 has this functionality built in to the contextual menu when you right click on results, but I only have 2005.

Am I out of luck?

Thanks for any help.

It works if you SELECT * FROM VIEW_NAME in a regular query window. If you Open a view like you Open a table to show data, it won't copy the columns - that's a different, editable grid.

Tools, Options, Query Results, SQL Server, Results to Grid. There's an option in there for it.