Community

Generate INSERT scripts from SQL Server queries and stored procedure output

(Jeffrey Yao) There are multiple ways via SQL Server Management Studio (SSMS) or dynamic SQL that we can generate a SELECT script that includes both the column name and the column value. This is useful to port data to other databases or to just have the data in a script that can be used to repopula

Read More - Register for Free Membership