SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
How to script the query results?

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
How to script the query results?
Author Message
THenrich



Joined: 17 Dec 2014
Posts: 11
Country: United States

Post How to script the query results? Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6739

Post Reply with quote
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 View user's profile Send private message
THenrich



Joined: 17 Dec 2014
Posts: 11
Country: United States

Post Reply with quote
There's no Save as Script option. I am using SSMS 2014.
Wed Aug 22, 2018 11:50 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6739

Post Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.