I have datatable with a big amount of data in it and I'm trying to export the data from it. I saved the file locally but I cannot open it with Notepad++. The problem is that I just want to get some of the data as an INSERT script but I don't know if this is possible.
Can anyone tell me if it's possible to get some of the data from a table as an INSERT script using SQL Server 2014?
Here is one way to do what you want (taken from this post:
NOTE: The above sample uses the schema name
temp. You may have to create that schema name for the script to work for you.