Author |
Message |
THenrich
Joined: 17 Dec 2014 Posts: 20 Country: United States |
|
How to script the query results? |
|
How do I script the query results as insert statements? I right clicked on the grid and I don't see an option to script the data. I am using SA 10 beta.
|
|
Wed Aug 22, 2018 2:58 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7951
|
|
|
|
Execute the query. Right-click the the result data grid and select "Save as Script..." menu.
if you want to script the entire table, just right-click it in DB Explorer. choose "Script Data..." menu
|
|
Wed Aug 22, 2018 8:30 am |
|
 |
THenrich
Joined: 17 Dec 2014 Posts: 20 Country: United States |
|
|
|
There's no Save as Script option. I am using SSMS 2014.
|
|
Wed Aug 22, 2018 11:50 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7951
|
|
|
|
I guess you are looking at wrong grid.
Use Ctrl+Shift+F9 or right-click menu -> SQL Assistant -> Execute/Schedule SQL -> Execute SQL... menu to execute the query
|
|
Wed Aug 22, 2018 11:53 am |
|
 |
|