 |
SoftTree Technologies
Technical Support Forums
|
|
| 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: 7948
|
|
| |
|
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: 7948
|
|
| |
|
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 |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
