Converting Select results into Insert script – SQL Server
Here is another method, which may be easier than installing plugins or external tools in some situations: Do a select [whatever you need]INTO temp.table_namefrom [… etc …]. Right-click on the database in the Object Explorer => Tasks => Generate Scripts Select temp.table_name in the “Choose Objects” screen, click Next. In the “Specify how scripts should … Read more