How to change *
[asterisk symbol] into list of column names? I can view the list of column names after placing mouse cursor over the *
. Is it possible to click-crack on something to change the *
into names without running the script an inserting the results into some dbo.temp table?
So the desired results would be:
with A as (select
MyColumn1=1
,MyColumn2=2
,MyColumn3=3)
select
MyColumn1
,MyColumn2
,MyColumn3
from A
Converting * in a cte to column names in Management studio
... select * into MyTable from A
Script table as Select
if you prefer column names with []delete MyTable